SUMMARY

• 8+ years of experience in designing and implementing Business Intelligence systems which include data warehouse architecture, ETL/ELT pipelines, reporting and analytics tools.
• Expertise in SQL Server 2008/2012, SSIS, SSRS and SSAS.
• Experience with SQL and T - SQL in constructing tables, normalization techniques to design relational database, stored procedure functions, views, dynamic query, exception handling, triggers
• Expertise in generating data insights. Provided self-serve reporting capabilities for Business Owners using Power BI, Power View and Power Pivot.
• Expertise in ETL development using SSIS integrating with various backend database sources, Analysis services, Excel, XML, SQL Database and others.
• Expertise in generating various reports using SSRS integration with web application. Good exposure in various financial, trend analysis, real time reporting and ad-hoc analysis.
• Supported Customer Business reviews by creating dashboards on key metrics to diagnose business performance and provided deep dive capabilities by creating drill functionality using hierarchies, filters.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Proficient in OLTP, OLAP and Data warehousing Design concepts.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Experience in MDX, querying cubes, and creation of cubes using SSAS.
• Expertise on Performance tuning, Query optimization, developing ETL strategies using SSIS.
• Good experience in database design and creating relational integrity constraints using SQL Server 2012/2008R2
• Expertise in developing various reports using SSRS, Crystal reports and integrating it with .Net. Involved in complete SDLC, which includes requirement gathering, analysis, design, development and Implementation.
• Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Experience in creating XML files and XSD schema files.
• Good experience on working on Web application using .Net Framework 1.1/2.0. Knowledge of .Net Framework 3.5.
• Possess clear and effective communication skills. Staged/represented ideas to client side senior managers, Partners and Directors.
• Received several recognitions and accolades for mining/discovering/developing tools/utilities to enhance team productivity with reduced effort.
• Conducted trainings on SQL 2008/2012 SSIS 2008/2012, SSRS 2008/2012.
• Good exposure in executing project on agile methodology.
• Possess expertise in software development process as per CMMI Level 5 standards.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

ETL: SSIS 2012/2008 R2/2005

Design Expertise: ETL design architect, Reporting Solution, Robust Data Warehouse Methodology, Agility Framework, Master Data Management Framework

Analysis: SSAS basics

Self-Serve BI: Power BI, Powerview, Powerpivot

Reporting: SSRS 2005/2008,2008 R2 Crystal Reports

RDBMS: SQL Server 2005/2008, My SQL, Oracle 10g

Languages: C#, VB.Net, T-SQL, PL-SQL

Visual Tools: Visual studio 2010/2012/2013

Scripting Language: VB Script,Power Shell script

PROFESSIONAL EXPERIENCE

Confidential, LA, CA

Sr. SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created Business Intelligence Systems by performing end to end activities such as writing SQL queries, loading databases and creating reports for the Finance Organization
• Designed and Automated ETL pipelines from various heterogeneous source systems into aggregated databases using SSIS environment
• Created SSIS Packages with complex transformations including variables and configuration files within the code
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Worked with Data migration utilities (Import & Export - BCP, Bulk Insert) from text to SQL Server
• Used SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.
• Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various revenue modules
• Designed various DB Objects like User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks
• Analyzing and improved query performance using tuning methods such as validating the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
• Designed Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Developed a Tabular Reports, Ad-Hoc Reports and Reports supporting Business reviews using SSRS Report Designer
• Reviewed Reporting Requirements and Created Aggregated Tables and Stored Procedures for the Dashboard for Management systems.
• Handled the database components (Code migration, version control) for application releases.
• Converted Business requirements to technical specifications, developed test plans for data validation consistency and reliability supporting day time SLAs.
• Involved in Database Administration activities like Back up, Security, Migrations in the Development servers.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Configured Subscriptions and Security for all critical reports. Partner with business stakeholders to deliver requirements which light up high value scenarios and ensure data quality and consistency.
• Collaborate with infrastructure operations to ensure the service implementation follows best practices for performance and monitoring.
• Partnered with clients to understand technical bottlenecks and suggest for solutions to overcome those and improve business.

Environment: MS SQL Server 2012, MS SQL Server Reporting Services 2012, SSIS 2012, SSAS 2012, Windows 7, MS Office.

Confidential, Thousand Oaks, CA

Sr. SQL BI Developer/SSIS Developer

Responsibilities:

• Collaborated with various business groups while developing their applications, assisting in Database design, creating E-R diagrams
• Involved in dimensional modeling with Star &Snowflake schemas and created the Data Source Views Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Wrote variousT-SQLqueries,Stored Proceduresand used them to build packages.
• Involved in designing the physical databases model on SQL Server 2008R2 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing Constraints and Triggers for data integrity in development database
• Created SSIS Packages to populate data from various data sources.
• Created packages using SSIS for Data Extraction from Flat Files, Excel Files, and OLE-DB to SQL Server.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Monitored Performance and Fine-Tuned the database objects and server to ensure efficient data retrieval
• Created a number of Cubes, Dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using Custom groupings that the company will use to analyze performance.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension Hierarchies based on the OLAP reporting needs.
• Created calculated measures, dimension members using MDX, mathematical formulas and user Defined functions, named calculations using SSAS for generation of cubes.
• Scheduled the Main Stored procedure on a schedule basis by creating a SQL Server Job Agent and also implemented efficient error handling techniques
• Create and execute unit, functional and integrated testing
• Responsible for Drafting, Documentation for describing the Metadata and writing technical guides
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Constructed Cubes based on data volumes mostly adhering to Star Schema
• Reviewed Reporting Requirements and Created Aggregated Tables and Stored Procedures for the Dashboard for Management systems.
• Developed a Tabular Reports, Ad-Hoc Reports using SSRS Report Designer.
• Deployed Reports, created Report schedules and subscriptions. Managing and securing reports using SSRS.
• Created different Parameterized Reports (SSRS2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Used various report items like tables, sub report and charts to develop the reports inSSRSand upload into Report Manager.
• Running DBCC consistency checks and fixing data corruption in application databases
• Configured SSIS packages using Package Configuration wizard to allow packages run on different environments
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data marts
• Migrated SSIS Packages from SQL Server 2005 to SQL Server 2008.
• Developed Complex SSRS Reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa
• Work with project teams for upgrading SQL Server 2005 to SQLServer2008R2.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application
• Database and Transaction log backups & restoration, backing up user databases and restoring them whenever necessary.

Environment: MS SQL Server 2008 R2/2008/2005, SQL Server Integration Services (SSIS), SSRS, MS SQL Server 2008 Management Studio, T-SQL, SQL*Profiler, SQL*loader, DTS, Windows 2008/XP, Erwin r4, Windows.

Confidential, Atlanta, GA

SQL/ SSIS /SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Maintained data integrity by performing validation checks.
• Responsible for creating the reports basing on the requirements using SSRS 2005.
• Defined the report layout.
• Identified the database tables for defining the queries for the reports.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports and cascaded reports.
• Identified and added the report parameters.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
• Deployed the generated reports on to the server.
• Formatted the reports using the Global variables and expressions.
• Optimized Queries, Tuned and Monitored server performance.
• Create Parameterized SSRS Reports and ETL packages using SSAS Cubes
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Developed SSIS solution for developing a full-fledged data warehouse solution
• Developed, monitored and deployed SSIS packages.
• Assisted in migrating deformalized report DB into a Star Schema design.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005,MS SQL Server Integration Services 2005 Windows Vista, MS Office.

Confidential, Cincinnati, OH

SQL Developer/ SSIS/SSRS Developer

Responsibilities:

• Develop an ETL strategy for migrating the data from various sources to the required databases which would use them to trigger the report generations process.
• Developed SSIS Packages to transfer the data from source to staging and then to the target with all validations and transformations done.
• Developed SSIS packages with Package Configurations
• Have implemented SCD type1, type2, and type 3 in SSIS Packages.
• Deployed and scheduled SSIS Packages as per the business rules
• Developed a SSIS Job to Process and schedule the SSAS cube
• Created data sources, data source views and dimensions
• Implemented Hierarchies, measures and calculated members and aggregations in the MOLAP Cube.
• Created a Report model and developed SSRS reports based on it.
• Generate adhoc Reports such as chart, matrix and table reports for Statistical Users using SSRS Report Builder
• Developed SSIS Packages to transfer the data from source to staging and then to the target with all validations and transformations done.
• Deployed and scheduled SSIS Packages as per the business rules.
• Design deployment of various reporting needs by business.
• Prepared the release notes and is responsible for sending BOM (Bill of materials) after each seamless deployment

Environment: MS SQL Server 2005, SSIS 2005, SSRS 2005,T-SQL, SSAS 2005, MS Office, Windows XP.

Confidential 

SQL Developer/ SSIS/SSAS Developer

Responsibilities:

• Gathered Requirements from the end user and checking the structure of the schema.
• Reviewed cube, changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.
• Updated functional specification and technical design documents.
• Created SQL server Analysis Projects using MS SQL Server 2005.
• Created the data source views for security reasons.
• Responsible for scheduling the jobs to streamline and automate cumbersome repeated tasks.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
• Involved in defining Referenced Relationships with the measure groups and fact tables.
• Defined Granularity within a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SSAS, SSIS, MS Access.