SUMMARY

• MS BI developer with around 8 years of experience in designing and developing BI applications. I am a strong team player and I enjoy interfacing with customers. I am flexible and easily adapt to new environments and technologies.
• 8 years of total experience as a SQL/BI Developer.
• 5 years of MSBI experience
• 1+years of POWER BI developer experience.
• Experience in working Agile SDLC’s
• Good @ SSIS, SSRS, SSAS, Power BI,SQL etc.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS ), Analysis Services (SSAS) , and Reporting Services (SSRS) .
• Technically and logically very sound in T - SQL Programming, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration , Data warehousing, Business Intelligence etc.
• Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Designed Star, snowflake schemas for Data Warehousing and OLAP needs
• Created various types of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Good at logical, physical, and dimensional data modeling, data mapping, and data normalization.
• Worked on DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes.
• Publishing Power BI Desktop reports created in Report view to the Power BI service.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals
• Good in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drilldown reports using MS SQL Server Reporting Services.
• Data migration from Excel, Flat file and Teradata to MS SQL Server by using SSIS packages
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) , Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Proficient in building Cubes , defining Referenced Relationships and creating Hierarchies in SSAS.

TECHNICAL SKILLS

RDBM/Databases: MSSQL Server 2016/2014/2012/2008 R2, Oracle 8i & 9i, MS Access, Microsoft Azure

Programming Languages: T-SQL, MDX,DAX, C

Data Modeling: FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional and multidimensional modeling and De-Normalization Techniques

BI Tools: Visual Studio (SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), SQL Server Reporting Services (SSRS)), Microsoft Power BI, Power Pivot, Power View, Power Query, Power Map, Tableau.

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Profiler, Import & Export Wizard, SQL Server Agent, Integration Services Catalog, Visual Studio Team Foundation Server (TFS).

Application Packages: MS Office, Microsoft SharePoint Server (MOSS)

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers.

PROFESSIONAL EXPERIENCE

Confidential, Stockton, CA

SSIS/SSRS Developer

Responsibilities:

• Coordinate with the team to understand the ETL, Analytics and Reporting requirements for the projects and create ETL packages using SSIS for data loads, creating dashboards and reports using SSRS or tools like Tableau.
• Gather requirements from the business to create and design best practice ETL design plans.
• Automate the ETL packages using proxy in SQL Server Job Agent for populating the data warehouse with the daily incoming data from source systems like Cerner, Healthnet etc. for all the team requirements and monitor the scheduled jobs and provide production support in case of job failure using the log data.
• Working on a project for developing the entire physical data model from existing logical data model, from creation of tables to developing ETL packages with all the required transformations, auditing, logging in each step to load data into the warehouse and automating the entire process.
• Worked on Cerner DA2 platform to populate the data ware house by scheduling the XCW’s (Standard) and custom-made reports. And created SSIS packages and scheduled jobs every day to populate the data from the EHR to the data ware house.
• Worked on data validation using Cerner Power chart to validate the data errors and find solutions.
• Had worked a little on HealtheIntent new platform of Cerner which is based on HP vertica.
• Responsible for providing the data requirements for the all the regulatory reporting needs and the hospital requirements.
• Provide all the data requirements for PRIME reporting (California State Regulatory reporting) for grants to the hospital around 20 million dollars a year for a period of 5 years.
• Been active in maintaining the databases, backups of databases, scheduling jobs using SQL server agent, maintaining those jobs and troubleshooting issues in case of failures
• Created SSRS reports to keep track of all the updates, database maintenance, table updates for the team to keep them updated about the production data.
• Document all the incoming bad data and get it reviewed to maintain data integrity.

Environment: MS SQL Server, Microsoft Visual Studio, Cerner, BIML Express, T SQL

Confidential, Mount Laurel, NJ

Power BI / MSBI Developer/ SQL Developer

Responsibilities:

• Analysis and design documents for implementing the client specific requirements
• Working on Performance Reports of employeesin Power BI which was a pilot technology to the company and have been key in helping them introduce the technology.
• Creating multi-dimensional cubes with hierarchical security and created Power BI dashboards on it.
• Wrote DAX functions for creating various visualizations in Power BI.
• Cascading reports with multiple parameters and cube source.
• Written complex T-SQL queries, stored procedures to build specific logics.
• Performing ETL operations to support incremental, historical data loads and transformations using SSIS.
• Implemented advanced features and tools such as script task, lookup, derived columns, condition split, union all, copy column, data conversion as per the business requirements.
• Worked on group atlas travel project which was one of the critical and new domains of Confidential . Have worked from the scratch of the project and built the application based on all the business rules with direct meetings with the clients.
• Developing reports using SSRS on statistical data during migration of data.
• Creating Tabular, drill down and Matrix Reports Quarterly, Semi-Annually and Annually by using SSRS
• Generated reports in excel files using SSIS for business reviews

Environment: MS SQL Server,T-SQL, Microsoft Visual Studio, Power BI.

Confidential, Chicago, IL

SQL Tester / Power BI Developer

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Validated parent-to-child relationships in the data. Set up data scenarios that test how orphaned child records are handled.
• Validated and corrected the dependency fields and check the same values against lookup tables.
• Involved in installation of SQL Server and assisted in creating users and assigning them appropriate access rights.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Written complex joins to validate query performance on large database volumes and worked with business users for acceptable performance criteria for each query.
• Developed and designed the different visualization charts like line charts, Pie charts, Tiles, Cards, Images, Tables, Bubble and scatter plots, key performance indicators using Power BI.
• Involved in requirement gathering for the Power BI dashboards and help end user understand the feasibilities in the reports.
• Used power BI with DAX for developing reports and KPI’s for the organization and departments.
• Provided ongoing support and configuration for JIRA projects, workflow, screens, fields, permissions and other administrative tasks.
• Experience in working with Azure SQL Database Import and Export Service, also deploying SQL databases in cloud.

Environment: MS SQL Server,T-SQL, Microsoft Visual Studio, Power BI, JIRA, Microsoft Azure

Confidential

SQL Developer/ SSAS Developer

Responsibilities:

• Installed and configured SQL Server 2008 for Development Purpose.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Created DTS packages to transfer the data from Oracle to SQL Server 2008.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses (since stored procedures passes the whole block at one time).
• Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer.
• Involved in performance tuning of the database and T-SQL queries using Explain plan.
• Developed triggers on views to populate these tables.
• Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update and delete.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote complex SQLqueries to perform Data Validation and Data Integrity testing. Used TOAD against Database.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.
• Used Power Pivot to develop data analysis prototype and Power Map to visualize reports also created analytical reports and dashboards using Power View.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Used SSAS MDX to extract data from cubes and create MDX script for representing cube calculations.

Environment: Microsoft SQL Server,Visual Studio, PL/SQL, TOAD, T-SQL,SQL Profiler, Query Analyzer, Power View, Power Pivot

Confidential

Software Engineer

Responsibilities:

• Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
• Worked with DDL, DML, and DQL in T-SQL using CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, FROM, WHERE, ORDER BY, and GROUP BY.
• Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
• Responsible for quick response of SQL statement and connectivity from front application to the database servers.
• Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created SSIS packages to populate data from various data sources.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Involved in automating SSIS Packages using SQL Server Agent Jobs. Created an ETL summary report which consists of the summary information for all the loading activities done each day and month. Rewriting and optimizing Queries, Preparing Documentation and specification.
• Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.
• Created many Complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI Functionality of SQL Server.
• Expertise in creating Perspectives, partitions and design aggregations in cubes using SSAS.
• Provided design, implementation and maintenance for custom reports and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.

Environment: Microsoft SQL Server, Visual Studio, MS SQL Server Management Studio (SSMS), T-SQL.