SUMMARY:

• Around 8 years of IT experience in Microsoft SQL Server 2005/2008//2008 R2/2012/2014, SSIS/SSRS/SSAS in OLTP and OLAP (Data warehousing) environments, PowerBI .
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with Good knowledge in SQL Server Analysis Services (SSAS).
• Involved in designing, developing the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (SQL Server, Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS like Data Conversion, Conditional Split, Lookup, Slowly Changing Dimensions(SCD), Audit, Derived Column, OLEDB Command.
• Extensive working experience in usage of SSIS Control Flow items such as Execute SQL Task, Script Task, FTP Task, Execute Process and Package Tasks, Send Mail Task and Containers.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Experience in enhancing and deploying SSIS Packages from development server to production server.
• Experience in providing Logging, Error handling by using Event Handler and also creating Break Points and Check Points.
• Experience in creating Jobs, SQL Mail alerts and scheduling SSIS Packages using SQL Server Agent.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Responsible for creating SQL datasets for Power BI and Ad - hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Created, scheduled various reports in Power BI like Tabular Reports.
• Experienced on creating multiple kinds of Report in Power BI and present it using Story Points.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Parameterized reports, Cascaded reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experience in deploying created reports in various sources like Web browser, XML and PDF And creating Linked reports, Subscriptions, Snapshot and Cache Reports in Report Management.
• Experience in understanding and designing of Star and Snow Flake Schema used in relational, dimensional and multidimensional data modeling.
• Experience in creating SSAS Tabular models.
• Performed data cleaning, data validation, and data analysis using Data Analysis Expressions (DAX).
• Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).
• Knowledge in developing cubes using KPI's, Calculations, Partitions, Perspectives, and created various user roles (SSAS).
• Expert in writing MDX queries with experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS).
• Experience in transforming complex business logic into Database design using RDBMS concepts and Data Warehouse Concepts.
• Experience in creating tables, stored procedures, views, triggers, functions, indexes, data integrity, data dictionaries, and relational database models.
• Experience in writing T-SQL queries, joins, CTE’s, dynamic and sub queries.
• Experience in developing T-SQL (DDL, DML) statements, Rules, Data Integrity (constraints) and Validation issues.
• Experience in developing logical and physical data models using Erwin and ER/Studio.
• Experience in Database Backup and Database Recovery in SQL Server 2014/2012/2008 .
• Expertise in software integration testing and SDLC(Software Development Life Cycle).
• Excellent technical, Analytical, Communication and Interpersonal Skills. Proficient in Technical Writing and Presentations and a Good Team Player.

TECHNICAL SKILLS:

Operating Systems: Windows (All Versions), Linux

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000, MS Access, Oracle 8i & 9i, MS Access, MYSQL.

Database Design Tools and Data Modeling: Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Physical And Logical Modelling, Dimension Data Modelling, Fact Tables, Dimension Tables, Normalization, Denormalization, MS Visio.

Modelling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modelling, ER Diagrams

BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Reporting Services (SSRS 2005/2008/2012 ) SQL Server Analytical Services (SSAS 2005/2008/2012 ), Data Transformation Services (DTS), Visual Studio, BIDS, Power BI, Tableau.

Tools: SQL Server Management Studio, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS),Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest, Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2.

Programming: C, C++, HTML, XML/XSLT/.Net/C#,Core-Java,T-SQL,PL/SQL, VB.NET

PROFESSIONAL EXPERIENCE:

Confidential, Princeton, NJ

SQL/SSIS/SSRS/SSAS/POWER BI Developer

Responsibilities:

• Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on daily basis.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Developing and deploying SSIS packages, configuration files, and scheduling jobs to run the packages to generate data in CSV files.
• Creating and managing Report subscriptions and schedules SSRS reports.
• Analyzed old reports designed in crystal reports and transform those reports into SSRS reports with proper mapping and error handing.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R 2/2012/2014.
• Developed SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Developed Scorecards/Reports for the system using SSRS, Power BI.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS).
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Responsible for debug, performance checks and performed index tuning and query optimization.
• Developed impactful reports using SSRS, MS Excel, Pivot tables and Tableau to solve the business requirements.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.

Environment: MS SQL Server 2016/ 2014/2012/2008 R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Agile, C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), MS Excel, Excess, Windows 8.

Confidential, Reston, VA

SQL MSBI Developer

Responsibilities:

• Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Formulated and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
• Created triggers, stored procedures, functions and wrote T-SQL queries to support efficient data storage and manipulation and also to capture updated and deleted data from OLTP systems.
• Created packages to validate, extract, transformation and load data to centralize SQL Server using OLEDB providers from existing diversified data source.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, For Loop and For-Each Loop Container, Execute-SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Union All etc.,
• Implemented SSRS solutions, used dashboards and gauges to enhance for the business users.
• Created Parameterized reports and Linked reports with the knowledge of report server architecture. (Table, chart and matrix report).
• Deployed and Generated SSRS reports using the Reporting Services, Report Manager and Microsoft SharePoint 2010.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database Using SSIS for Data transformation.

Environment: SQL Server 2008/2008R2/2012/2014 Enterprise Edition, .NET 3.5, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise Manager, XML, PowerPoint, Microsoft Visio 2007, Access, Windows Server, Business Objects.

Confidential, Norcross, Georgia

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in gathering business requirements, interacting with the client and preparing detailed design document.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Managed SQL Servers in 32/64bit Clustered environments. Implemented Database Mirroring on SQL Server 2008 environments.
• Involved to set up SQL Server configuration settings, to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Created and optimized database objects such as views, functions and stored procedures as per requirement.
• Filtered corrupted data from legacy system using T- SQL and implemented constraints and triggers into new system for data consistency.
• Designed and developed the ETL data flow to populate the Cube Analysis Database using the SSIS packages ( SQL Server Integration Services). Scheduled and automated packages to populate the data in the cube daily up to date for business reporting.
• Created SSIS Packages by using transformations (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting etc.,).
• Identify the field/column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the SSIS packages. Identify and document the source to target packages.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Design and document the error-handling strategy in the ETL load process using Event handlers.
• Created OLAP cubes using SSAS and created reports from them.
• Designed and built cube using SQL Server analysis Services (SSAS 2008) with 10 dimensions and built daily partitions.
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models and developing reports using MDX and T- SQL.
• Created test data and unit test cases to ensure successful data loading process.
• Used Notification services to generate error messages and send them to the user through e-mails. Created report snapshots to improve performance of SSRS.

Environment: MS SQL Server 2012/2010/2008 R2, T- SQL, Microsoft SQL Server Integration Services (SSIS) 2012/2010/2008 R2, Microsoft SQL Server Reporting Services (SSRS) 2012/2010/2008 R2, Microsoft SQL Server Analysis Services (SSAS) 2012/2010/2008 R2, SQL Server Business Intelligence Development Studio, Star Team Version Control tool), Erwin 8.0.

Confidential, Atlanta, GA

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created and managed stored procedures, indexed views, user-defined functions, triggers, and database constraints to meet business requirements and policies.
• Created complex queries for database auditing purposes.
• Used DTS/SSIS for ETL processes, SSRS for reporting needs, and SSAS for analytics reporting including SharePoint integration.
• Created complex SSIS packages using various data transformations like conditional splitting, fuzzy lookup, multi-cast, column conversion, fuzzy grouping, script components, and error handling.
• Generated custom ETL scripts using SSIS 2008 and unit tested load processes for performance check.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Gained understanding of OLAP processing for changing and maintaining warehousing, optimizing dimensions and hierarchies and adding aggregations to cube.
• Involved in writing MDX queries and performance optimization of SSAS cubes for calculated members and measure groups.
• Created various complex reports and managed them using SSRS 2008R2/2008 according to ERLC.
• Involved in migration and conversion of reports from SSRS 2008 to 2008R2.
• Created tabular reports, matrix reports, list and chart reports, parameterized reports, sub reports, ad-hoc reports, drill-down reports and interactive reports according to business requirements in time-restricted environment.
• Created SSRS report model projects in BI studio and created, modified, and managed various report models with multiple model objects, source fields, and expressions.
• Highly involved in creating, structuring, and formatting using Report Designer and Report Builder.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server and SharePoint.
• Deployed designed Performance Point Services (PPS)dashboards and reports in MOSS site using PPS Dashboard Viewer Web Part for web-based access for multiple end users.

Environment: SQL Server 2008/2008R2/2012 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise Manager, XML, MS Office, Access, Windows Server, Oracle, SharePoint.

Confidential, Cranbury, NJ

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Created database architectures and designs in SQL Server 2005.
• Defined and Implemented Processes and Procedures for QA Departments.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, Parameterized Reports and Linked Reports etc., using SSRS
• Designed Report Templates, Bar Graphs and Pie Charts based on the sales data.
• Worked on querying data for Creating On-demand Reports using Report Builder in SSRS and sent the reports via email.
• Defined Report Layouts for formatting the report design as per the need.
• Generated test data and tested new database consistency with existing databases.
• Identify and recommend database techniques to support business needs.
• Created SSIS packages using control flow and data flow items and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Deployed different SSIS packages on development and test environments.

Environment: Windows 2007, MS SQL Server Management Studio 2008/2008R2, Visual Studio 2008, T- SQL, MS Access, MS Excel, SSIS, SSRS, SharePoint, BIDS.

Confidential

SQL Server Developer

Responsibilities:

• Created new tables, views, indexes and user defined functions.
• Actively designed the database to fasten certain daily jobs and stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing T- SQL statements for retrieval of data and involved in performance tuning of T- SQL queries and Stored Procedures.
• Used SQL Analyzer and Profiler for studying the SQL statements and procedures.
• Perform daily database backup & restoration and monitor the performance of Database Server.
• Created joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Data migration from Text to SQL Server.
• Created reports in SQL server as per the requirements provided by the Frontend users.
• Developed Stored Procedures and Views to be used to supply the Data to the Reports. Complex formulas were used to show derived fields and to format the data based on specific conditions.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Extracted and transformed Data from OLTP databases to the specific database designed for OLAP services.

Environment: SQL Server 2008, Integration Services (SSIS), SSRS, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS).