SUMMARY:

• 8 years of IT experience as a SQL Developer in Database Development, System Analysis, Implementation, and support of MS SQL Server.
• Extensive Experience in Data Modeling, ETL (Extract, Transform and Load), Database Design, Development, and Reporting.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS, creating mappings/ workflows to extract data from SQL Server Excel file, Flat File sources and load into various Business Entities Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• In - depth knowledge in ER Modeling and Dimensional Modeling (Star and Snowflake Schema) building Dimension and Fact tables.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Well versed in Using MDX (Multi-Dimensional Expressions) Queries to retrieve data from Multi-dimensional SSAS Cubes.
• Good knowledge in exploring data in a Variety of ways and across multiple visualizations using Power BI.
• Hands on experience in creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Hands on experience in Creating, Maintain & schedule various reports in Power BI like Tabular Reports.
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
• Expertise in Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI and SSAS.
• Efficient in migrating existing data into the Power BI.
• Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Experience in report generation using Server Reporting Services (SSRS) from relational databases and OLAP cubes.
• Good working experience in creating reports using stored procedure and Experience in building Repor

PROFESSIONAL EXPERIENCE:

Confidential

SQL Data Engineer/ SQL Developer

Responsibilities:

• Debugging SSIS packages which have issues running in Prod at that specific point of time and Monitoring packages. Working on snapshot data to load from transactional systems to Datawarehouse.
• Creating Dashboards and Enhancements to existing dashboards on Power BI. Communicate with users to get all accurate requirements for the changes to undergo. Created data models from the source data and created Power BI reports from scratch. Using Dax to create calculated Measures and calculated columns based on the requirements. Used M language to get the functionality through transform data in Power BI. Implemented Incremental processing in power BI for the snapshot data.
• Worked on creating data sets in power BI which can be used by different teams in the organization to create Power BI reports. As a part of Deployment team, used to deploy SSIS packages, SSAS cubes to Production on weekends. Worked with Azure Cloud services, created Pipelines to load data in text files from Raw to Curated zones using U SQL, scheduled them in Azure Devops and monitor those pipelines. Performance tuning of Multi - Dimensional cubes by creating partitions and aggregations which used to take long time to process every day. Good Experience in Partitioning SSAS cubes based on the cube structure, schema and data sets and writing Stored Procedures to process the cubes on daily bases to reduce the processing time. Worked on creating
• Aggregations for Multi-Dimensional cubes to increase the performance of queries which are being reported by the clients from developed cubes.
• As Partitioning in Multi-Dimensional cube depends on both processing the cube and query performance. Extensively used Power BI and MDX for Multi-Dimensional cubes based on the complexity of the measure and requirement.
• Created Stored Procedure, functions, indexes (Clustered, Non-Clustered), tables, semantic views and SQL joins utilizing latest DML and DDL syntax. Debugging existing SSRS reports as well as making changes and enhancements if needed. Scheduling the SSIS Packages through JAMS and Monitoring.

Confidential

SQL Developer/ SSIS/ SSAS/ POWER BI Developer

Responsibilities:

• Created Physical Model Designs and Logical Model Designs for the new projects with estimating time and effort to complete the project. Used SSIS package (ETL) to transform data from MYSQL (RDBMS) data warehouse to
• SQL server database and to convert data into framework with PK's, indexes and remove duplicate rows. Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like Excel, CSV, Flat file, Text formatted data by using different transformations present in SSIS such as Merge, Conditional Split, Union all, Script task, OLE DB command, data conversion, Look - Up, Transformation and more. Good Experience in Partitioning SSAS cubes based on the cube structure, schema and data sets and writing
• Stored Procedures to process the cubes on daily bases to reduce the processing time. Worked on creating Aggregations for Multi-Dimensional cubes to increase the performance of queries which are being reported by the clients from developed cubes.
• As Partitioning in Multi-Dimensional cube depends on both processing the cube and query performance. Extensively used DAX for Tabular cubes and Power BI and MDAX for Multi-Dimensional cubes based on the complexity of the measure and requirement. Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. Created multiple dashboards in Power BI for automating the testing process. Created Stored Procedure, functions, indexes (Clustered, Non-Clustered), tables, semantic views and SQL joins utilizing latest DML and DDL syntax.
• Operated performance tuning on the tables and Semantic views which take more time to query the results by creating indexes on the fact tables. Extensively Worked on cursors, CTE's, Schemas, Permissions Performance issues with Client and Server-side database design. Implementing Security roles on SSAS cubes and Power BI services by implementing authentication and authorization methods. Scheduling the SQL Server Agent Jobs and monitoring the scheduled jobs daily, where most of the jobs loads data into staging tables and process SSAS cubes.
• Handed deploying SSIS packages, SQL scripts, SSAS cubes into Production environment and supporting them for any new enhancements or big fixes. Proficiency in using Source Control in TFS (Team Foundation Server), creating user stories tasks and keeping the Source control updated with updated codes of DB scripts, SSIS packages, SSAS cubes. Good knowledg

Confidential

SQL Developer/ 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 a daily basis. Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files. Create and manage Reports subscriptions and schedules SSRS reports. Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub - reports using Report Designer and Report Builder based on the requirements. Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS. 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) projects. Created many calculated columns and measures using DAX in Power BI based on report requirements. Involved in Tabular Data Warehouse and DAX operations for
• SSAS 2012 and 2008 OLAP databases. Troubleshooting reports issues, ETL job failures, optimizing query performances. Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers. Created several 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. Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R 2/2012/2014/2016. Extensively worked on Dimensional modeling
• Data cleansing and Data Staging of operational sources using ETL processes and good experience in SSAS. Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS. Develop 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. 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.

Confidential

SQL Developer/ SSIS/ SSAS/ SSRS Developer

Responsibilities:

• Extracted data from different sources and stored the data into the intermediate Staging Database using SSIS ETL tool. Maintained all the SQL documents including installation and data conversion Procedure documents. Developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to Data Warehouse. Extensively used SSIS Import/Export Wizard for performing the ETL operations. Complex business requirements were transformed into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and
• Lookup. Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2012. Developed several reports with consistent drill - down functionality including Drilldown reports, Summary reports and Master
• Detail reports. Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database. Created Calculated Measures and Key Performance Indicators in SSAS using MDX. Querying and manipulating multidimensional cube data through MDX Scripting in SSAS. Creating multi-dimensional cubes using SSAS and designing DW schemas. Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems. Developed Custom Functions, Manual Running Totals and Complex Formulas for reports. Experienced in implementation of strong referential integrity and auditing by the use of triggers. Prepared the complete data mapping for all the migrated jobs using SSIS. Deployed the SSIS Packages to the MSDB as well as File System based on the requirements. Designed ETL Packages with Microsoft SSIS 2012 to pull data from various sources like DB2, SQL Server
• Teradata, Flat Files and other systems to individual Data marts which ultimately go into Enterprise Data Warehouse (EDW). Involved in the development of custom SQL, T-SQL, custom stored procedures, functions, and triggers. Created Teradata External loader connections such as Upset and Update, Fast load while loading data into the target tables in Teradata Database. Worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients. Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages to run sequentially using SQL Server Agent job and windows Scheduler. Developed Cross-Tabbed and Sub-Reports in SSRS 2008R2. Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008R2. Used breaks, calculations, sorts, filters, and sections to enhance data presentation in reports. ETL process was

Confidential

SQL Developer/ SQL BI/ SSIS/ SSRS/ SSAS Developer

Responsibilities:

• Created SSIS Packages which contained different transformations and tasks. Troubleshoot SSIS Packages and convert to SSRS Reports. Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008/2012. Developed SSIS packages using various transformations such as Conditional
• Splits, Fuzzy Look Ups, Aggregations, and Multicasting. Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs. Created packages in SQL Server Integration services which import the data from share point to reporting server database using connection strings.
• Developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to Data Warehouse
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages. Involved in monitoring and tuning report performance by analyzing the execution plan of the reports. Extensively involved in using Formula fields, parameter Fields, Group Selection, and Record Selection in Crystal Reports. Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow - Flake Modeling, Fact, and Dimensions Tables using MS Analysis Services. Developed web pages for embedding deployed SSRS reports using ASP.NET

Environment: SQL Server 2008/2005 Enterprise Edition, T-SQL, Visual Studio, SQL Server Management Studio (SSMS), T-SQL, SSIS, SSRS, SSAS, Visual basic, SQL Server Agent.

Confidential

SQL Developer/ SSRS Developer

Responsibilities:

• Created ETL SSIS packages both design and code to process data to target databases Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis Performed database transfers and queries tune - up, integrity verification, data cleansing, analysis and interpretation.
• Developed, monitored and deployed SSIS packages Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc
• Implement automated Index Maintenance strategy run as SQL Job on a daily basis. Resolving any dead locks issues with the Databases/Servers on a real-time basis. Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further
• Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, BizTalk Server 2004 Erwin, Microsoft Visio 2003, SFTP