SUMMARY

• Experienced MS Business Intelligence Developer with 7+ years of experience working with BI applications such as SSMS, SSIS, SSAS in Development, Test/QA and Production Environments, visualization tools such as Power BI, SSRS and Tableau.
• A wide experience working in different industry domains such as healthcare, service, insurance, ecommerce. whose core business encompasses one of the largest property and casualty insurance groups in the Japanese domestic market.
• Hands on experience in installing, configuring, managing, upgrading/migrating, monitoring and troubleshooting SQL Server 2017/16/14/12 /08 R2;
• Expertise in SQL Server Integration Services (SSIS) particularly in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert;
• Used Python to pull data for ETL through REST - API in JSON and XML formats and transfer it to datawarehouse staging table.
• Data validation and testing using Python.
• Excellent in High Level Design of ETL/SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, flat files, MS Access, SAS, Oracle, DB2, SalesForce, CRM) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Derived Column, Merge, Merge Join and Union all;
• Experience in report development using Power BI/SSRS/Tableau and creating various types of Dashboards and reports with Drill Down/Through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports features;
• Skillful in developing PBIX files in both Power BI Desktop and Power BI Services platforms and in uploading them into Report Server and Cloud Services with proper row level security settings;
• Seasoned in building Tabular models within Power BI Desktop and writing complex DAX queries to create measures and calculated columns;
• Highly skilled in Analyses Service, particularly in building both Tabular and Multidimensional models (OLAP, Cubes) on top of DW/DM/DB, and writing complex DAX and MDX queries against the models;
• Competent in creating Databases, Tables, Complex Stored Procedures, DDL/DML Triggers, Views, User Defined Data Types, User Defined Functions, Cursors and Indexes (clustered, non-clustered, column stored) using T-SQL;
• Solid understanding in maintenance and administration of SSIS by creating SQL Agent Jobs, Alerts, Mail Notifications, and schedule DTS/SSIS Packages by SQL Agent, Windows Scheduler and other third-party tools;
• Hands on experience in Data Modeling in all Conceptual, Logical and Physical stages and in creating both Star and Snow Flake Schema data models in data warehouse concepts;
• Well knowledgeable in Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions and JAD sessions for requirements gathering, creating data mapping documents and queries;
• Experience in migration of on-premise SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM, and developed and maintained databases across both on-premise and cloud deployments.
• Proficient in Software Development Life Cycle (SDLC) process, which includes RUP, Agile and Waterfall methodologies.
• Hands on experience on PolyBase, and JSON parsing.
• Strong skills on deploying and operating large scale cloud infrastructure and application services in Azure, AWS, SAP, Oracle Cloud, Google Cloud, IBM Software and other Cloud providers
• Experience in Data Conversion and Data Migration using SSIS/DTS services across different databases like Oracle, MS access and flat files;
• Expert in Performance Tuning of complex T-SQL Stored Procedure, SSIS Packages, Power BI/SSRS Reports;
• Experience in SQL server MDS 2012 features including hierarchies, granular security, transactions, data versioning, and business rules;
• Excellent leadership, analytical, communication and interpersonal skills and proficient in writing and presenting complex technical concepts, comfortable working independently and with different size of teams, self-motivated and goal oriented.

TECHNICAL SKILLS

OS: Windows XP/7/10, Windows Server 2016/12/08, UNIX/LINUX

Databases: SQL Server 2017/16/14/12 /08 R2, Oracle 11g/8.0i, MS Access 2000/8.0, Teradata 14.0, DB2 AS400

Languages and web tools: T-SQL, PL/SQL, MDX, DAX, C#, Python, VB.NET, XML, MYSQL, HTML, ASP.NET, .NET Framework, JSON

ETL & Reporting: SSDT 2017/16/14/12 , BIDS, SQL Server Integration Services (SSIS 2016/ 2014/2012/2008 R2), SQL Server Reporting Services (SSRS 2016/2014/2012/2008 R2), SQL Server Analysis Services (SSAS), Cognos, Tableau, PolyBase, Azure

Others: MS Office, MS Visio, Service Oriented Architecture (SOA), SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports, SAP Business Objects, DataStage, Informatica, Hadoop, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, MS VSS, Synergy, HP Quality Center, Jira, CA Agile

PROFESSIONAL EXPERIENCE

Confidential, Addison, Tx

SQL EDI / ETL Integration Developer

Responsibilities:

• Extensive experience in designing ETL/ELT processes to load dimension and fact tables using SQL server, Oracle, Netezza and Postgre SQL databases.
• Used Python to pull data for ETL through REST-API in JSON and XML format and transfer it to staging table.
• Also done Test data modification using Python.
• Implemented advanced SSIS concepts to handle complex tasks like importing large files, loading data in a transactional database etc.
• Processing the data into the data warehouse using slowly changing dimensions type1, type2 and type3 models.
• Leading Key meetings including status meetings, and other meetings during the implementation process with clients
• Debugged the processes to make sure data is mapped/processed correctly which provides a qualitative check of overall data flow.
• Managed the Relational Database Management Systems, Database Physical and Logical design, Data Mapping, Data Normalization, Creation of DB Diagrams, OLTP, and OLAP systems.
• Troubleshooting issues and implement performance tuning techniques by determining the bottlenecks of slow running processes.
• Implemented various performance tuning techniques using Indexing, query optimization, parameterized queries, CTE’s, SQL server profiler, database engine tuning advisor, IO stats, explain plans etc.
• Developed and deployed scripts with step-by-step instructions, create change requests (RFC’s) and deployed ETL packages/database scripts to DEV/QA/UAT/PROD Servers.
• Used PolyBase to query tables and files in Hadoop and in Azure Blob Storage
• Generated custom interactive dashboards using SQL server reporting services, Tableau for the end users.
• Outbound and Inbound data tracking and reporting.

Confidential, NJ

SQL BI SSIS, SSRS/PowerBI Developer

Responsibilities:

• Involved in writing heavy T-SQL stored procedures, complex joins, new T-SQL features like Merge, Except commands
• Developed data standards, data exchange, XML data standard or data sharing model.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy LookUps, and Derived Columns with Multiple Data Flow tasks.
• Used Python to pull data for ETL through REST-API in JSON and XML format and transfer it to staging table.
• Also done Test data modification using Python.
• Done and cheked for data doing test data validation Using Python.
• Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed event types.
• Worked with re-directing outputs into different formats including XML Files and various other data sources.
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third-party tools.
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.
• Worked on XML Web Services Control Flow task to read from XML Source.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File and DB2 into the data warehouse.
• Interpreted data, analyzed results using statistical techniques and provided ongoing SSRS and PowerBI reports.
• Created, maintained and updated ETL packages loading from/to both OLTP and OLAP database tables.
• Developed and implemented data collection systems and other strategies which optimize statistical efficiency and data quality.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Acquire data from primary or secondary data sources and maintain databases/data systems
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Filter and “clean” data, and review computer reports, printouts, and performance indicators to locate and correct code problems.
• Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).
• Work closely with management to prioritize business and information needs.

Confidential, NY

ETL/SSIS Developer

Responsibilities:

• Created Complex ETL Packages using SSIS for extracting, cleaning, transforming and loading data from staging tables to partitioned tables with incremental load.
• Developed, deployed, and monitored SSIS Packages.
• Data ETL making changes to existing ETLs and building some new ETL processes.
• Data Automation Using SSIS to automate data processes for input of information.
• Implemented data validation by using T-SQL queries to confirm that SSRS reports data results that are being returned are correct.
• Worked closely and communicate with project team members to achieve project goals.
• Created packages using the various control flow tasks such as Data Flow Task, Execute SQL Task, Execute Package Task, File System Task.
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
• Created number of standard reports and complex reports to analyze data using Slice & Dice, Drill Down and Drill Through approaches using SSRS.
• Participated in design discussions with Database architects and Application architects.
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Developed SSIS packages to extract, transform and load data from Oracle and SQL Server databases into Data Warehouse.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Created Indexes for faster data retrieval from the database.
• Wrote Stored Procedures and Functions for better performance and flexibility.
• Deployed SSIS packages into various Environments (Dev, UAT and Prod) using Deployment Utility.
• Coordinated with Users in different testing phases.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB and SQL client.
• Good hands on experience with C#.NET and VB.NET for downloading files from a remote server.
• Strong skills in transformation data from DB2 to SQL Server
• Created and Designed Data Source and Data Source Views and configured OLAP Cubes (Star and Snow Flake Schema) using SSAS.
• Involved in Dimensional Data Modeling and Cube Partitioning in SSAS and enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions using SSAS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Developed Multidimensional Objects (Cubes, Dimensions), designed Dimensional Modeling and created Hierarchies using SQL Server Analysis Services (SSAS).
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs and deployed cubes.
• Created Parameterized, Cross-Tab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.