SUMMARY

• MS Business Intelligence Developer with several years of experience working with BI applications such as SSMS, SSIS, SSRS, SSAS in
• Development, Test and Production Environments, visualization tools such as Power BI and Tableau. A wide experience working in different industry domains such as healthcare, service, insurance and finance.
• More than 7 years of IT experience in Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
• Extensive knowledge and experience in dealing with RDBMS including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Involved in all phases of SDLC (Software Development Life Cycle) which includes RUP, Agile and Waterfall methodologies, from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience in using Knowledge Modules to extract data from XML, CSV and flat files and load into databases.
• Actively participated in gathering of User Requirement and System Specification.
• Documented the data flow and the relationships between various entities.
• Comprehensive knowledge of Software development life cycle ranging from Business Requirement gathering, Designing Databases,
• Developing Applications, Unit Testing, System Integrity Testing and User Acceptance Testing.
• Experience in reviewing and analyzing functional specifications and project specifications and develop solutions to user problems.
• Excellent understanding and knowledge of Normalization/de - Normalization.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Strong knowledge with Host Scripting to automate routine tasks.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Thorough knowledge of addressing Performance Issues and Involved in Query tuning, Index tuning, Data profiling and other database related activities.
• 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.
• Expert in creating Parameterized Reports.
• 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.
• Hands on experience in creating Star Schemas and Snow Flake Schemas.
• 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
• Excellent analytical, communication and interpersonal skills and proficient in writing and presenting complex technical concepts, comfortable working independently and with different size of teams.

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.0Languages

T-SQL, PL/SQL, MDX, DAX, C#, VB.NET, XML, ASP.NET, .NET Framework, C#

Web Tools: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML5, 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/2014/2012 /2008 R2), PowerBI, SQL Server Analysis Services (SSAS)

Others: MS Office, Crystal Reports XI, Visio, SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, MS VSS, HP Quality Center & Jira

EXPERIENCE

Confidential, Pleasanton, CA

SQL BI SSIS, SSRS Developer

Responsibilities:

• Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter and Remove duplicates stages were extensively used to Cleanse/Transform the data extracted into staging.
• Modified and tested PL/SQL stored procedures.
• Worked with subject matter experts to prepare source to target mapping document for the migration project.
• Developed data warehouse process models, including sourcing, loading, transformation, and extraction of source data (from Oracle).
• Develop SQL Scripts (OPENQUERY) to validate the data after the loading from Oracle database.
• Created MDX SSRS reports and deployed them in SharePoint.

Confidential, San Francisco, CA

Lead ETL/SSIS Developer

Responsibilities:

• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• 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.
• Data transformation 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.

Confidential

Sr. SQL BI Developer

Responsibilities:

• Run SQL Server SSIS packages to load and transform to the SQL Server data warehouse.
• Create SSIS packages for Varian migration project and provide step-by-step instructions for vendors how to run in and generated files from their Database
• Create Access DB templates to search data files for customers as needed, create SQL scripts to load users into an Oracle DB by querying the data warehouse for data.
• Multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• 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
• 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.
• Worked extensively on system analysis, design, development, testing and implementation of projects.
• 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.
• Created SSRS and PowerBI reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with MDX and DAX.

Confidential, Houston, TX

SQL BI SSIS, SSRS/PowerBI Developer, Conversion-Data Analyst

Responsibilities:

• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS and performed documentation for all kinds of reports and SSIS packages.
• 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.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
• 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.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).