SUMMARY:

• Over 8 years of experience in Data Warehouse Architecture and Design, Analysis, Dimension Modeling, Business Intelligence strategy, Development, Testing and Implementation.
• Expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS 2008 R2/2012.
• Extensive experience in generating on - demand and scheduled reports/dashboards from both relational databases and OLAP cubes using SQL Server Reporting Services (SSRS) and Tableau.
• Experience in designing, creating, processing of cubes using SSAS.
• Extensive experience in developing Stored Procedures, Views, Triggers, XML and Complex SQL Queries on SQL Server 2008 R2/2012.
• Experience in designing Star schema and Snowflake schema with Facts, Dimensions, Measures and Cubes using Erwin.
• Extensive experience in Health Care, Finance, Insurance domain and government projects.
• Exposure in using Team Foundation Server as a source control, source repository and project tracking solution.
• Excellent analytical and problem solving skills.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

ETL/BI: SSAS, SSIS, SSRS 2005/2008 R2/2012, DTS, SQL Server BI Development Studio (BIDS), Tableau, crystal Reports, Performance Point, Power View

Tools: Erwin 7.2, ER/Studio, Visual Source Safe (VSS), Team Foundation Server (TFS), SQL Profiler, Microsoft Office, Visio, Microsoft SharePoint

Databases: Microsoft SQL Server, Oracle 9i/10g, DB2, Microsoft Access, Flat file systems

Languages: SQL, PL/SQL, T-SQL, shell scripting, C, C++, Java, J2EE, Visual Basic

Domain: Finance, Banking, Healthcare, Insurance and Government projects

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer

Responsibilities:

• Extensively worked with the business analysts in requirements gathering and to translate business requirements into technical specifications.
• Responsible for Dimensional Data Modeling and populating the business rules into the repository for Meta Data management.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Performed data consistency check and Performance tuning.
• Used tools like SQL Profiler, Performance Monitor to find out performance issues with queries or applications
• Created SSIS Packages to load data from Sources like Excel, Oracle and SQL Server.
• Wrote numerous stored procedures to perform data cleaning/loading task once data is loaded into staging area.
• Created reports by extracting data from cube and wrote mdx scripts.
• Created data mining structures.
• Generated Dashboards from OLTP and OLAP data sources using SQL Server Reporting Services 2012, Performance Point and Tableau.

Confidential, Washington DC

ETL Developer

Responsibilities:

• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Responsible for design, development, and implementation of ETL processes using SSIS
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Performed unit testing, system testing and user acceptance testing of reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared Layouts by placing the fields in appropriate places according to the requirement of the final Report.
• Created report models and deployed them on the report server.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Created report snapshots and cache for better performance.
• Used Notification services to generate error messages and send them to the user through e-mails and pager messages.
• Created ad-hoc reports, drill down, and drill through reports.
• Deployed reports on Microsoft office SharePoint (Moss).

Confidential

Lead ETL Developer

Responsibilities:

• Business Reporting Requirements gathering and analysis.
• Responsible for Dimensional Data Modeling and populating the business rules into the repository for Meta Data management.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Responsible for Developing OLAP Cubes, Data Source View, Partitions of queries with MDX.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Deployed the generated reports directly on the client’s workstation.
• Created complex Stored Procedures for better performance in generating reports.
• Created dashboards and scorecards using charts.
• Deployed reports on share point performance server.
• Created standard and data driven Subscriptions and used report manager.
• Created report model for Ad-hoc reports and generated reports in XML format.
• Used Team Foundation Server (TFS) for version control, source control and reporting.
• Prepared documentation for all kinds of reports and DTS and SSIS packages.
• Trained and mentored internal staff on data warehousing.

Confidential

ETL Developer

Responsibilities:

• Translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
• Created and scheduled various SSIS packages with embedded business logic.
• 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.
• 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 complex report calculations.
• Created parameterized reports passing parameter through report screen.
• Rendered reports in different formats like pdf and excel to be executed automatically on weekly or monthly basis and managed subscriptions.
• Analyzed the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Documented all database objects, procedures, views, functions & packages for future s.

Confidential

ETL Developer

Responsibilities:

• Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Implemented replication in SQL Server for managing and scaling databases in an enterprise environment.
• Designed and implemented Dimensions, Measures and Cubes according to business requirement using sql server analysis services (SSAS 2005).
• Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting and SQL parameters.
• Created Dashboards in SSRS 2005.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Increased query performance necessary for statistical reporting by more than 25% after using Execution plan, Performance Monitor, Profiler, and Index tuning wizard.
• Created Datasets in T-SQL, stored procedures for SSRS.
• Developed SQL queries and supported ad hoc requests for data.
• Involved in troubleshooting data quality issues in reports and resolving them.