-
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