Sql Server Data
Resume:
Meenu Sharma
STATUS - GREEN CARD
Objective BI Analyst
Summary
• 4+years of experience in SSIS, SSAS and SSRS of MS SQL Server.
• In-depth knowledge of T-SQL queries.
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors,, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Proficient in implementing all transformations available in the SSIS toolbox.
• Experience in Data Extraction, Transforming and Loading (ETL) Excel, SQL Server, Oracle, DB2 and Flat file. Involved in transformation of OLTP data to the Enterprise Data Warehouse.
• Experience in Agile Methodology and expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes.
• Designed operational and dashboard reports using SSRS and Performance point.
• Designed SSAS data cubes with complex dimensions and fact tables.
• Familiar to convert crystal reports into SSRS.
• Excellent communication and interpersonal skills. Desire to excel, learn new technologies, hardworking and a versatile team player.
Technical Skills
RDBMS/DBMS: MS-SQL Server 2005/2008 r2, Oracle 8i/9i/10g/11g, MS Access, DB2.
Programming Languages: T-SQL, MDX, PL/SQL, ASP .NET and VB6 .NET
IDE & BI Tools: SSRS, SSAS, SSIS, SQL Server Management studio, Crystal Reports, Informatica and SQL Server BI Development Studio (BIDS).
Operating Systems: Windows 2000, Advanced Server and Windows 2003 Enterprise Server.
Version Control: Visual SourceSafe (VSS), Team Foundation Server (TFS).
Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, ER Studio.
Work Experience
Lafarge Corp. Toronto, ON Jun 2008 to Jun 2012
SQL Server SSIS/SSRS/SSAS Developer
Description - The scope of the project was a CRM based inventory-management service a application provided by Lafarge which enables customers to track their orders and manage the inventory by reports. The project requires Extract & load data to data warehouse, create reports and cubes.
Responsibilities:
• Created SSIS packages to extract data from DB2, Oracle and Excel spreadsheet and load to SQL Server data warehouse.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Scheduled Cubes Processing from Staging Database Tables using SQL Server Agent
• Wrote MDX expressions to create name sets and calculated members.
• Optimized cubes for better query performance. Processed cube to perform incremental
• Created operational reports by SSRS and designed dashboard by using performance point and deployed to share point.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Worked with business to validate report design and requirements. Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• worked on TFS for task management and file management of SQL server code.
• Created and tuned stored procedures and SQL queries. Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Knowledge of Maximo asset mgmt for specifications, monitoring, costing and tracking
Environment: SQL Server 2008/2005, BIDS 2005, Reporting services
2005, Integration Services 2005,Analysis Services 2005, Windows Server 2003, Oracle 9i,DB2,JAVA Share point server2010, TFS, Excel, Power Point, Visio, Access.
CIBC Bank Toronto, ON Aug 2006- Jun 2008
SQL Server Developer/SSIS/SSRS
Description - This project requires monitoring of billing services by using daily, weekly and monthly SSRS reports.
Responsibilities:
• Worked with Business Analysts and Users to understand the requirement.
• Maintained design structure (Schema) by directing implementation of SQL standards and guidelines.
• Created Stored Procedures, triggers, views, tables and designed SQL queries for the application.
• Created SSIS packages to extract data from various data sources like oracle, db2 and SQL server to ODS.
• Identified the Measures and Dimensions and designed data cubes by using BIDS. Deployed data cubes in SSAS and did unit testing of the data.
• Created operational and deck reports by using SSRS. These reports were critical for business to perform their daily tasks.
Designed dashboards and scorecards reports according to business requirement by using SharePoint and performance point.
• Created complex Stored Procedures for better performance to generate reports.
• Created standard and data driven Subscription, used report manager for securities.
• Utilized Team Foundation Server (TFS) for version control, source control and reporting.
Environment: SQL Server 2005, SSIS, SSRS, Query Analyzer, Index Tuning Wizard-SQL MS Access, MS Excel, ERWIN, Windows Server 2003 Enterprise Edition, Share point performance server
Toronto Dominion Bank Toronto, ON Nov 2006 –Aug2007
SQL Server Developer(SSIS/SSRS/SSAS)/ETL
Description - Project was to alter the process to meet the new business requirements associated with the customer equity trading and performance.
Responsibilities:
• Extracted required mapping fields from different sources (schema, CDW) to Sales Force Warehouse for Staging Table.
• Analyzed and performed Data mapping which involves identify source data field, transformation rules and lookup tables.
• Developed SSIS Packages not only for particular table’s fields and required data types for lookup tables in Staging but also for data Warehouse requirements of CDW.
• Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic.
• Used sub reports functionality for drill down reports.
• Created parameterized reports passing parameter through report screen.
• Experience in working with stocks and bonds.
Environment:
Windows XP/2003 Enterprise edition, MS SQL Server 2005/2008, Excel 2003, Visual Studio 2005, TFS, VBScript, Database Engine Tuning Advisor, Profiler SQL Server Management Studio 05, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS.
Education
• Bachelors in Computer Science - University of Saskatchewan, Canada
• 10 weeks part-time course in SAP BI 7.0 from IIBS, Toronto ON
Contact this candidate