SUMMARY

• Strong experience in using the Microsoft BI Stack (SSIS, SSRS, SSAS and SQL). Worked with SQL server 2012/14/16
• Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration from various type of sources (Excel, flat file, csv, XML, OLTP DB etc.), Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.
• Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors. Expert in troubleshooting SSIS packages using a variety of techniques/tools.
• Experience in designing and developing considerable number of reports in SSRS using the data from ETL Loads, Proficient in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
• Created OLAP applications with OLAP services in SQL Server and built multi - dimensional cubes.
• Good knowledge of Data Marts, operational data store (ODS), OLAP, Star schema modeling, Snow flake modeling for fact and Dimension tables.
• Experience in Microsoft Power BI Suite (Power Query, Power Pivot, Power BI Pro, Power BI Desktop), Microsoft Excel Pivot Table, and Data Models to gather information from multiple sources and deliver information to the end user.
• Working knowledge of building statistical KPI reporting dashboards with predictive analysis.
• Excellent DAX Skills and the ability to create and troubleshoot complex calculations and measures
• Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks.
• Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.
• Leverage Knowledge of SAP BW Data Management, ETL to contribute to the over all Planning by recommending approaches, identifying and developing timelines
• Proficient in ETL process from both ECC and other sources to SAP BW and SAP HANA Application Layer
• Extensive experience in SAP HANA Data provisioning technology including SAP LT, Data Services, and developing data models in SAP HANA 1.0 & 2.0,
• Expertise in SAP HANA Advance Modeling by creating different Calculation Views, Analytical Views and Attribute Views based on Input Parameters, Variables, Hierarchies, Calculated Columns, Restricted Columns,
• Expertise in developing Analytical Solutions Using SAP HANA and SAP Business Object Tool set like Web Intelligence, IDT, Analysis For Office, SAP Business Objects BI Platform Java Launch pad.

TECHNICAL SKILLS

Operating Systems & Environments: Server 2012/2014/2016

Databases (RDMS): SQL Server 2012/2014/2016 , MySQL, Access, Oracle 9i,SAP HANA

Administrative, Modeling, Tuning & Troubleshooting: SQL Server Management Studio (SSMS), SQL Profiler, SQL Server Agent, Windows Scheduler

Business Intelligence: SSIS, Integration Services Catalogs, Power BI, Import/Export Wizard, SSAS, SSRS, Report Manager, Report Builder, SAP BW

Integrated Development Environments: SQL Server Business Intelligence Development Studio (BIDS), Visual Studio 2015/2016, SAP BW

Languages: T-SQL, C, VBScript, DAX

Source Control: Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE

Confidential

Power BI/SQL Developer

Responsibilities:

• Worked with business teams to gain a rich understanding of their business, analytical, and reporting needs, including the identification of critical metrics.
• Performed detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples.
• Worked closely with a team of technical and non-technical staff and consultants to iterate through versions of the deliverables.
• Involved in creation of various Business Intelligence/ Analytical Dashboards utilizing Power BI with global filters, calculated columns and measures using complex DAX calculations and transformations using Query Editor & Power Query Formula Language (M).
• Worked on Power BI dashboards using stacked bars, bar graphs, scattered plots, waterfall charts, geographical maps, Gantt charts using show me functionality.
• Publishing of various kinds of live interactive data visualization dashboard reports and workbooks from Power BI Desktop to Power BI servers.
• Managed a repository of re-usable data visualization templates and views.
• Supported the Business Intelligence/Analytics data analyst with the understanding of business and data requirements and iteratively designs visualizations for initial concepts and prototypes that can be presented to customers for feedback.
• Conducted Training sessions for Power BI users and created the documents for end user
• Involved in planning, defining, and designing database based on the business requirements document
• Implemented after insert, update and delete triggers to simultaneously populate multiple tables at once.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created SSIS packages to extract the data from multiple sources like Excel, XML and OLTP and consolidate them into staging tables.
• Maintained SSIS packages for production and test environment for incoming source application files.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Used Merge statement in SQL to only populate data warehouse tables with non-existing records.
• Used script component in SSIS (utilizing C# script) in order to validate source columns for each package.
• Used multiple SSIS transformations such as: data conversion, derived column, conditional split to cleanse and validate data.

Confidential

ETL Developer

Responsibilities:

• Database development utilizing Microsoft SQL Server OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation, and Loading). Database Administration including, backups, recovery, database maintenance.
• Handled development for reporting team involving coding, security, code reviews, metadata implementation, and replication troubleshooting
• Performed capacity planning and growth prediction for client audit data
• Query tuning based on query execution plans, statistics, and profiling
• Created code based solution for application error involving composite key manipulation
• Coded optimization objects including hierarchical flattening functions, strategic indexes, and staging tables as well as data and file partitioning
• Worked with development teams in the design of physical databases and in modification..
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Proficient in SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases .
• Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Generated and Deployed ETL SSIS packages both design and code to process data to target databases.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance
• Created XML schemas to update user tables and system objects for company data dictionary
• Served as a team member in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform.

Tools: and Technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), ETL, SSAS, XML, MS Excel, Agile.