SUMMARY

• Experienced MS Business Intelligence Developer with 7+ years of experience working with BI applications such as SSMS, SSIS, SSRS, SSAS in Development, Test and Production Environments.
• A wide experience working in different industry domains such as healthcare, service, insurance and finance.
• SQL/ETL Developer having 7+ years of IT experience in Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
• Experience in Information Technology with a strong background in Database development and Data warehousing using MS SSIS/SSAS/SSRS.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2016/ 2014/2012/2008 R2/2008.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions (SCD) and Dimensional Modeling (Kimball/Inmon methodologies, Star Schema and Snow Flake Schema)
• Experience in report development using SSRS and creating various types of reports like Dashboard, Drill Down/Through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in SQL server MDS 2012 features including hierarchies, granular security, transactions, data versioning, and business rules.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV and 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
• Experience in working with Web services to handle SQL connections.
• Strong skills on deploying and operating large scale cloud infrastructure and application services in AWS, Azure, SAP, Oracle Cloud, Google Cloud, IBM Software and other Cloud providers
• Strong knowledge with Host Scripting to automate routine tasks.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in Performance Tuning and Query Optimization.
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts and SSRS Reports with PPS.
• Experience in maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Expert in creating Parameterized Reports.
• Hands on experience in creating Star Schemas and Snow Flake Schemas.
• Excellent analytical, communication and interpersonal skills and proficient in writing and presenting complex technical concepts, comfortable working independently and with different size of teams.
• Proficient in Software Development Life Cycle (SDLC) process, which includes RUP, Agile and Waterfall methodologies.
• Proficient in designing Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Involved in designing and populating data in data warehouse and Cubes (OLAP) using SSAS and SSIS.
• Data Modeler with strong Conceptual, Logical and Physical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents and queries
• Migrated 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.

TECHNICAL SKILLS

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

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

Languages: T-SQL, PL/SQL, MDX, DAX, C#, VB.NET, XML, MYSQL, HTML, ASP.NET, .NET Frame Work, C#, C, C++, JavaScript

Web Tools: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script

ETL & Reporting: SSDT 2016/14/12, BIDS 2008R2/08, SQL Server Integration Services (SSIS 2016/ 2014/2012/2008 R2), SQL Server Reporting Services (SSRS 2016/2 R2), PowerBI, SQL Server Analysis Services (SSAS)

Others: MS Office, Crystal Reports XI, 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, Master Data management, Data Quality Services

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. BI Developer (SSIS, SSRS, SSAS, Power BI)

Environment: MS SQL Server 20012, MS SQL Server Master Data Services 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SAP Business Objects, BI Extractor, Microsoft Excel, Add-In Excel with Master data

Responsibilities:

• Developed SQL queries or stored procedures used by reports to retrieve information from relational database and data warehouse.
• Experienced in Microsoft SQL Server Enterprise Data warehouse including modelingdesignimplementation and troubleshooting
• Experience writing T-SQL functionsviews and other SQL Server constructs for use in ETL and reporting
• Create Common Table expressions (CTE) and temp tables to facilitate the complex the queries
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed queries or stored procedures using T-SQL to be used by reports to retrieve information from relational database and data warehouse
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Experience in working with partially / full blocking transformations and expertise in performance tuning of SSIS packages.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experienced in creating SQL JOBS and scheduling and set alerts.
• Working knowledge in creating Stored Procedures, Triggers, User-Defined Functions, Views, Indexes, User Profiles, Analytical Functions using T-SQL, SQL Server, PL/SQL.
• Developed queries via joining various tables to validate the data coming with different data discrepancies using existing fields and quantifying results with calculations.
• Expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Power BI Dax with good knowledge on SQL Server Analysis Services (SSAS).
• Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts.
• Experience in writing DAX in Power BI and Expert in fine tuning the reports.

Confidential, Atlanta, GA

Sr. SQL BI Developer (SSIS, SSRS, SSAS)

Environment: MS SQL Server 2016/20012, MS SQL Server Master Data Services 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio/.NET 2012, SAP Business Objects, BI Extractor, Microsoft Excel, Add-In Excel with Master data

Responsibilities:

• Involved in writing heavyT-SQL stored procedures, complex joins, new T-SQLfeatures like Merge, Except commands
• Developed data standards, data exchange, XML data standard or data sharing model.
• Developed SSIS packages usingLookup Transformations, Merge Joins, Fuzzy LookUps, and Derived Columnswith Multiple Data Flow tasks.
• Created XMLPackage Configurations,Error Handling usingEvent Handlersfor 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 automatingSSIS Packages usingSQL Server AgentJobs, 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 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.
• Architecture, Design and Implementation ofData Quality and MDM Customer/Locations/Product solutions managing the Global teams. Experience in integration MDM forData import/export.
• Responsible forData Profiling,Data Quality Rules, Match merge and Survivorship Discussion and Solutioning for Customer MDM.
• Support end userData management requests.
• Create biannual scorecard ofMDM progress, recommendation for forecasting futureData management tasks.
• Data Management Request Assignments thru SharePoint
• Created MDM andData processing flowcharting techniques
• CorrectsData issues and ensures consistent standardization to align withMDM policies.
• Utilize analytical tools and routines to maintain and improve thequality and integrity of vendor and itemMDM.
• Performed performance tuning and optimization of queries and stored procedures for reports that took longer execution time using MS SQL Profiler which were sent to clients and managers.
• Experience in working with Normalization/De-normalization, data design methodology and building Referential Integrity for the relational Database Model implementing as per business requirement.
• Flexible and project-oriented team player with excellent communication and leadership skills to develop creative solution for challenging client needs.
• Expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Power BI Dax with good knowledge on SQL Server Analysis Services (SSAS).
• Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts.
• Experience in writing DAX in Power BI and Expert in fine tuning the reports.

Confidential

SQL BI SSIS, SSRS Developer, Conversion-Data Analyst

Environment: MS SQL Server 2014/2012/2008 R2, SQL Server Reporting Services 2008/2012, SQL Integration Services 2008/2012, SQL Server Analysis Services 2008/2012, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.

Responsibilities:

• As a key member of BI team, delivered the best results to the development needs, accomplished successful outcomes by working with SSIS, SSAS and SSRS.
• Supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members.
• Participated in formal and informal training programs to improve technical skills and knowledge of all programmers (e.g. lunch and learns, articles, white papers).
• Trained/guided new or junior developers in certain development areas helped them to understand better the project process.
• Solved a lot of critical/challenge issues raised by the team about ETLs with C#.
• Developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, DB2 and Oracle into the data warehouse.
• Created the optimal logics to load the data that business rules were based on flat file names or ragged hierarchy.
• Created Incremental Load ETL packages using For Each Loops, Sequence Containers, Script Tasks, Conditional Split, Data Conversation, Derived Column, Lookup, Merge/Merge Join, Union all, etc. on BIDS 2008R2/2012.
• Participated in software quality assurance activities, including code reviews and unit system, integration, regression and performance testing.
• Understood and completed necessary documentation for the application/infrastructure change control process.
• Worked closely with business people and analyst team to deeply understand/analyze the requirements of business need and achieved the successful results.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed complex T-SQL Stored Procedures, UDFs, CTEs, Indexed Views, Staging Tables to process the data and populate them into the appropriate destination tables.
• Wrote C# hard codes in script task for ETLs, updated/maintained the ETL packages with high performance.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1/ type 2 changes.
• Administered the maintenance and movement of 835 files through clearinghouse and direct connection.
• Worked with EDP Power Reader to manage 835 files and involved in EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).
• Worked with the team/architect to create logical/physical modeling and created Cubes (fact, dimensions and calculations)
• Worked on various DAX expressions in Power Pivot based on the business requirement.
• Worked and updated to improve complex issues like Error Handling in SSIS for handling Delta load changes.
• Performed debugging, data analysis, and system analysis as required.
• Hands on Creating Parameterized reports, Cross-Tab reports, Drill down reports, Dashboard and Summary reports by using SSRS.
• Designed high level ETL architecture for overall data transfer from the OLTP to Data warehouse with SSIS and prepared ETL mapping processes.
• Created local variables and global variables package configurations and error handling.

Confidential

SQL/SSIS Developer, Data Modeler

Environment: MS SQL Server 2005/2008R2, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL server Analysis Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN

Responsibilities:

• Gathering, analyzing and documenting the business requirements and business rules by directly working with end users/clients.
• Created and maintained documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in scheduling and deploying SSIS Packages.
• Published SSRS reports in Report Manager, SharePoint web pages and in custom made ASP.NET web applications.
• Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the central OLTP database.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL codes and SQL joins for SSIS packages and SSRS reports.
• Extract, Transform and Load data from databases of systems like CRM, ERP and SharePoint
• Design, maintain and deliver SSRS reports sourcing from central database.
• Created Application Tracking Systems, Surveys and Manual Data Entry Web Apps using ASP.NET Framework.
• Implemented various tasks and transformations for data cleansing and performance tuning of SSIS packages.
• Extracted and Loaded SharePoint Lists and Surveys Data into SQL Server Database with SSIS
• Collaborated on multiple projects using GITHUB.
• Provided standard and ad-hoc reports on a regular basis and on demand.
• Worked extensively on system analysis, design, development, testing and implementation of projects.
• Developed and Maintained Crystal Reports.
• Extended SSIS Capabilities by Creating Custom SSIS Components for SharePoint.
• Configured SSIS packages with XML configuration file, Environment variable, Registry entry, Parent package variable and SQL Server table.
• Pulled data into MS SQL Server Database from different DBMS databases like Oracle and Teradata with ETL packages.
• Created SSRS reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with MDX and DAX.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.
• PromoteDQS, research anomalies, and solve problems.
• Responsible for automation ofdata flow and cleansing functionality of the hospital transactiondata
• Manage analysis and operations related to product catalog for platform. Act as automation lead for procedures related toDQS of platform.
• Manageservice data extract for all members spend analysis and reporting. Develop and refine reports in, SQL, SSRS, Access or Excel for external department use ad hoc requests.
• Identify and research potential and identifieddata issues.
• Interact with senior management, internal and external clients to address and resolvedata issues Develop, refine and standardize procedures fordata
• Researched, developed, and established standards and processes for cleansing team. Developed database to warehouse item record cleansing, replacing structures utilized by multiple teams.
• Created and launched database using SQL to manage and store product research while providing reporting for management team and Analysts.
• Construct user interfaces to client interfacing teams to access item cleansingdata and manage incoming client requests.
• Support the development and implementation of capabilities to improve, monitor, and auditData Quality.
• Expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Power BI Dax with good knowledge on SQL Server Analysis Services (SSAS).
• Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts.
• Experience in writing DAX in Power BI and Expert in fine tuning the reports.