Margaret E.( Business Analyst / Report Analyst )Skills: Access Database, SQL Server 2005/2008/2012, BIDS 2008/2010 Visual Studio, SQL Server Management Studio, T-SQL, Access database Query writing, Windows Server, XP, Windows 7 and 8, ETL - SSIS and Report – SSRS, Microsoft Word, PowerPoint, Excel, AccessExperience: 11+ yearsAvailability: ASAPLocation: Los Angeles, CA, US
- Experience in preparing and maintaining daily treatment of records, creating reports and presenting to team
- Knowledge of gathering Business Requirements, converted them into technical specifications by writing queries in Access/SQL
- Designed, Developed and scheduled the Quality Reports/ Adhoc Pivot Reports via Excel, Access Database & SSRS
- Wrote T-SQL (DDL, DML) statements, designed and created database and tables, constraints, and functions
- Experience in writing inner, left and right joins, sub query, union, union all and stored procedures.
- Knowledge of creating views, triggers & indexes,
- Knowledge of installation and configuration of MS SQL Server 2008/2012 versions.
- Extracted data from ISeries, SQL Server and other sources by creating SSIS packages in SQL server
- Knowledge of Scheduling Jobs, stored procedures and managing alerts through SQL Server Agent.
- Detail oriented with strong organizational, technical, Problem solving skills and decision making abilities.
- Team player and comfortable working independently.
- Quick learner who thrives in a fast paced environment and has the ability to meet deadlines and manage shifting priorities.
- Experience in analyzing the data records and collaborating with other professionals for developing more effective solutions
Didn’t find what you were looking for? Get full access to our database of available IT resources in North America and Europe!Get in touch now!