SUMMARY

• Over 7 years of IT experience in Database Design and Development on Microsoft SQL Server 2005/2008/R2/2012. Knowledge of software development life cycle (SDLC).
• Possess experience in independently handling design, development, documentation and testing phases in a project environment.
• Experience of Relational Database Management systems (RDBMS) and Database design issues like normalization and de - normalization.
• Extensive experience with T-SQL, Functions, Indexes, Triggers and Extracting data from multiple tables.
• Developed complex stored procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in building Data Integration and Workflow Solutions for data warehousing using SQL Server Integration Service (SSIS).
• Expertise in designing Data Flow task, Control Flow task and designed various SSIS Transformations like OLEDB Command, Conditional Split, Data Conversion, Aggregate, Multicast and Derived Column.
• Excellent in High Level Design of ETL Packages & SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Flat File, OLEDB) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experienced in performing Incremental Loads and Data cleaning in SSIS. Managed Error handling, logging using Event Handlers in SSIS.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix Reports, Tabular Reports, Charts/Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS.
• Good knowledge of defining, developing and deploying Star Schema, Snowflake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS).
• Involved in developing OLAP dimensions, cubes, and measures with SQL Server Analysis Services 2005/2008/2012 .
• Managed all database servers in development, Staging, test and production environments.

TECHNICAL SKILLS

• MS SQL Server 2005/2008/2012
• SSRS
• SSIS
• SSAS
• MS SQL Server 2008 R2
• Business Intelligence Development Studio (BIDS)
• Report Builder
• Windows XP/ 7/8
• SQL Profiler
• SQL Query Analyzer
• Data Analyst
• OLAP Services
• SQL Server Agents
• SAS/STAT
• SAS/BASE
• SAS/GRAPH
• PROC SQL
• SAS MACRO
• Tableau
• Crystal Report
• XL Miner

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SQL Server/BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (Flat files, Excel, Oracle, and SQL Server).
• Extract and Transform data into Staging Database and load data into data warehouse to create fact table and dimension table
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Responsible for creating SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Used try-catch block to handle the errors and to store all the errors in a table to handle them later and to continue the flow of execution.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• Used stored procedures and SQL joins in construction of dimension Tables using SSAS Assist. created worksheets and dashboards in tableau desktop
• Used for-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

Environment: Microsoft SQL Server 2012, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, Business Objects,, Windows Server, MS Visio, Oracle 9, MS Excel, Tableau.

Confidential, Chicago, IL

SQL Server/BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Implemented MS SQL Server and Business Intelligence Development Studio.
• Redesigned the Database using Common Table Expression(CTE), View, Stored Procedures, and Indexes
• Worked as a developer in creating complex Stored Procedures, tables, and views and other SQL joins and statements for applications
• Worked in developing, implementing and extracting, transform and load (ETL) processes from raw file, flat file, Excel, and OLE DB sources.
• Involved in data transformation like lookup, fuzzy lookup, multicast, merge, join, derived column.
• Involved in configuration and deploying the packages in SSIS, file system deployment and SQL server deployment
• Implemented in creating Job Alerts scheduling the packages and package execution
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted
• Scheduled the monthly/weekly/daily reports to run automatically.
• Deployed reports to a report server using SSRS Configuration Manager and created individual subscriptions for respective manager by enabling event driven schedules
• Experienced in developing the cube with single schema and also develop cube with multiple schema.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate view
• Utilized MDX scripts for querying the data from OLAP cubes (SSAS), and built reports on top of cubes.

Environment: Microsoft SQL Server (SSRS, SSAS, SSIS) 2012, T-SQL, Tableau 8.0, Crystal Reports, MS Visio, Windows Server, Power Pivot, MS Word, MS Access, MS Excel, MS PowerPoint, SSIS Catalog 2012, Microsoft Visual Studio 2010, Reports Builder.

Confidential, NY

MS SQL Server/BI/ETL developer

Responsibilities:

• Responsible for understanding the Business Analysis and requirement
• Designed, modified, and created database objects like views, indexes and stored procedures based on logical design models, user requirements and physical constraints.
• Migrated data from heterogeneous data sources like text files, flat files, MS-Access, Excel, OLE DB, files using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures.
• Applied various data transformations such as Aggregate, Sort, Multicast, Conditional Split and Derived columns.
• Using Bulk insert task in SSIS to load data from multiple flat files into the data warehouse.
• Created ETL SSIS packages to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Created configuration packages to move the package from development server to production server in SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Agent.
• Designed developed and deployed reports, sub-reports, drill down reports, and drill through reports and parameterized reports and adding new features to the reports in MS SQL Server environment using SSRS.
• Analyzed historical data by creating SSAS cubes and passed the data to created reports.

Environment: MS SQL Server Management Studio 2012, SSIS, SSRS, SSAS, SQL Profiler, XML, MS-Access, Visual Studio, BIDS.

Confidential, Daytona Beach, FL

SQL Server/BI Developer

Responsibilities:

• Worked with Project Manager and Business Analyst to understand business requirements and involved in planning, defining and designing data based on business requirements.
• Responsible for creating database objects using T-SQL to provide structure to store data and optimized Stored Procedures, Views, Triggers and UDFs for the application.
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from OLTP database to data warehouse database (OLAP).
• Performed data conversion from flat file into a normalized database structure.
• Configured Server for sending automatic emails to respective people when a SSIS process failure or success.
• Created SSIS jobs to automate the reports generation and cube refresh packages
• Deployed SSIS package into production environment and used package configuration to export various packages properties to make package environment independent.
• Developed different kinds of reports such as Chart reports, Matrix reports, Drill-down reports, Linked reports and Cascading Parameterized reports using SSRS.
• Involved in designing, analyzing, building and testing of OLAP cubes in SSAS
• Deployed all the reports to reporting server, SharePoint, Excel & PDF
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS
• Involved in System Study analysis for logical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.

Environment: MS SQL Server 2008, Integration Services (SSIS), Reporting Service (SSRS), Analysis Services (SSAS), MS Excel, MS Access, MS Visual Studio