SUMMARY

• Over 7.5 years of experience isSQLserver database and Data Loading and Reporting tools with SSIS, SSAS, SSRS, and Power BI.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Texting, Implementation and Maintenance.
• Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T - SQL, Database Design including ER diagrams, normalization.
• Expert in developing T-SQL(DDL, DML) statements, Data Integrity (constraints), Rules, Performing Tuning, Query Optimization and Data Validation issues.
• Created, Built and deployed successfully dynamic SSIS packages intoSQLServers databases and scheduled them according to the requirements.
• Created and Configured Data Source and Views, Dimensions, Cube, Measures, Partitions, KPI's & MDX Queries usingSQLServer Analysis Services and MDX.
• Proficient in Developing SSIS Package to perform ETL on data into the Data Warehouse (DWH) from Heterogeneous databases such as Oracle, DB2 and MS Access.
• Worked with RDBMS implementation usingSQL, PL/SQLand MySQL on Oracle Database.
• Expert in creating the MDX cubes and dimensions (SSAS).
• Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB connections from heterogeneous sources (Excel, CSV, Oracle, Flat files, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, ExecuteSQLTask, Data Flow Task, SCD, Lookup, Bulk Insert, Merge and union all.
• Expert in developing Data Warehouse architecture, ETL framework and BI Integration using Reports and Dashboards.
• Experienced in creating Jobs, Alerts,SQLMail Agent, and scheduling SSIS Packages.
• Experience in writing Parameterized Queries for generating stylish Tabular reports, Drill down, Drill through, Cascading, Parameterized, click through, Matrix, Chart, Snap shot reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Experience in working with large databases inSQL, Oracle and Teradata.
• Involved in SSAS cube maintenance activities including troubleshooting and Data Visualizations using SSRS and Crystal Reports and Power View.
• Knowledge in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot tables, scatter plots, pie charts and packed bubbles and use multiple measures for comparison such as Individual Axis, Blended Axis and Dual Axis.
• Widespread knowledge in using report building tools like PowerBI, Tableau and Qlikview.
• Experience in working at various levels of software development cycles such as Analysis, Designing, Developing and Testing & Implementation of business applications in Client Server/RDBMS for Windows platform.
• Good knowledge in Normalizing and De-normalizing the tables and maintain Referential Integrity by using Triggers and Primary and Foreign Keys.
• An empathetic listener and persuasive speaker with excellent written and verbal skills.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Senior SQL Developer

Responsibilities:

• Involved in development and implementation of SSIS, SSAS, SSRS application solutions for various business projects across the organization.
• Developed Custom Visualization in Power BI such as Liquid Fill Gauge, Bar Charts, etc. Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
• Wrote DAX Expressions, Power Query, Functions in Power BI.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Created various complex reports, Dashboards and manage those usingSQLServer Reporting Services.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad - hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• DevelopedSQLQueries for fetching complex data using joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Designed various kinds of reports on given data and some of the reports like cascade, parameterized and linked reports that will help to drill-down process in the report.
• To load the data from source to data mart, we used two packages i.e., Type 1 and Type 2 for incremental loading.
• We written complexSQLQueries for analyzing the data to design the reports for various stake holders.
• With the help of visualizations in Power BI, created various visualization like Pie charts, Bar graphs, Tree maps etc., that will helpful easily to understand the data.
• Holding the responsibility for deploying the SSIS packages and scheduling the packages through jobs in all phases including development, testing and production.
• Created different Facts and Dimension tables to increase the performance of complexSQLqueries that are used in SSRS reporting.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Derived Column, look up, Data Conversion, Merge Join.
• Used SSIS andSQLServer stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Extensively worked on production support that includes Deployment of SSIS packages into Development, Production Servers, Creating, Scheduling and Managing theSQLJobs.
• Extensively worked on ETL packages to extract, transform and load data from different sources like Excel, Flat files, ExecuteSQLTasks, Data Flow Task, Derived Columns Tasks.
• Worked on Execution of the paths depending on the success, failure or Completion of other tasks with precedence constraints and expressions to determine the workflow.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to Cloud.
• Shared reports in Power BI service to entire Organization in Office 365.

Environment: SQLServer 2012, T-SQL, PL/SQL, Excel, Power BI Desktop, Power BI Web, Azure Database, Visual Studio 2012, MS Excel.

Confidential, St. Louis, MO

SeniorBI/Power BIDeveloper

Responsibilities:

• Worked as adeveloperin creating complex stored procedures, triggers, functions, indexes, tables, views and other T - SQLcode andSQLjoins for applications.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate.
• Developed Queries for generating reports in SSRS 2012 for Complex Executive Dashboards and Customer Performance dashboards to analyze the KPI's for all global clients.
• Created database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQLinSQLServer.
• Used various transforms in SSIS to load data from accounting software Quick Books in the form of flat files to theSQLdatabases.
• Worked as adeveloperin creating complex Stored Procedures, SSIS packages, triggers, cursors, tables and views and otherSQLjoins for building various applications.
• Helped our customers with different refresh issues in the Power BI online service.
• Responsible for creatingSQLdatasets for Power BI and Ad-hoc Reports.
• Utilized Power BI for Office 365 to amplify data visualization with collaboration and data management.
• Developed multiple dashboards with Power BI depicting differing KPIs for business analyses.
• Implemented pivot/un-pivot, transpose features of Power BI to load data into excel Power Pivot.
• Employed bar charts, bubble charts, and Power map to answer business questions with Power BI.
• Created, maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Studied the existing OLTP system(s) and interacted with Data Architect regarding facts, dimensions and star schema representation for the data mart.
• Involved in recreating the analytical reports using MS Access Database using SSRS to eliminate any Manual Processing.
• Involved in integrating SSRS Reports with QR Codes, Micro QR Codes, and Standard barcodes using third party applications to track the Samples at various levels from receiving to testing.
• Created Accounting Reports based on Quick Books data for Region wise sales, sales by client, Sales by State, quarterly sales for all the Global clients.
• Experienced in using Power-Pivot for analyzing the raw data and team meetings and during requirements gathering.
• Created SSRS Report to automatically print the label for the Sample Scheduling for the Analysts, eliminating the manual process and paper based approach.
• Involved in both Unit Testing and Integration Testing to ensure all the software deliverables are following the end user business and technical requirements.
• Involved in embedding the SSRS Reports and Dashboards in the internal web applications.
• Worked on the POC of Creating Monthly Quality Assurance Reports, letters for some of the exclusive clients and setup subscriptions to deliver these Reports based on a schedule.
• Involved in generating several Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Worked on caching the reports to improve the Report Retrieval Time.
• Used SVN to manage the team's software development lifecycle including deriving product backlog items and conducting sprint review meetings.
• Actively involved in User Acceptance Test (UAT) for various end-users across the departments, to explain them the full functionalities of the SSRS Reports and Dashboards.
• Worked with high level end-users, communicating the progress and developments in a timely manner.

Environment: SQL2012, MS Reporting Services 2012, MS Access, Visual Studio,SQLServer Integration Services 2012, Tortoise SVN, T-SQL, Micro QR Readers, Windows XP Professional, MS Excel 2013, Power Pivot, Power BI, Power View.

Confidential, Trenton, NJ

MSBI Developer

Responsibilities:

• Integrated ceding companies claim data, from heterogeneous data sources (flat file, csv) and legacy system (DB2, Access, Excel) into centralized data warehouse using SSIS.
• Created staging areas for data processing (cleansing, validation, audition) and transformation (aggregation, lookup, filter).
• Studied the existing OLTP systems and interacted with Data Architect regarding facts, dimensions and star schema representation for the data mart.
• Used open queries to fetch data from DB2 source systems.
• Used Bulk Binds and Records processing to improve the performance of processing.
• Created views, Indexed Views, Power pivot to support internal Reporting requirements and modified the existing reports based on End User Requirements.
• Used different kinds ofSQLJoins to join more number of tables.
• Extracted data from Oracle, MSSQLdatabases to create Pivot tables need for the end users.
• Involved in Extraction, Transformation and Loading (ETL) of data in the data warehouse for DB2 database using Informatica and SSIS.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Participated in the migration of applications to quality assurance and the production environment.
• Performed necessary production support tasks involving on - call responsibilities both during and after work hours.
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file,SQLTables and windows event log.
• Involved in User Acceptance Training (UAT) with user to create reports using Report Builder tool.
• Generated reports using Global Variables, Expressions and Functions for the reports.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Used Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle including deriving product backlog items and conducting sprint review meetings.

Environment: MSSQLServer 2012, MS Reporting Server, Report Builder, Microsoft Visual Studio 2012,SQLIntegration Services 2012, T-SQL, Windows XP Professional, MS Excel.

Confidential, Santa Clara, CA

SQL/BI Developer

Responsibilities:

• Worked on the Reports module of the project as adeveloperon MSSQLServer 2008 R2 (using SSRS, T - SQL, scripts, stored procedures and views).
• Filtered and cleansed bad data from legacy system using complex Transact -SQLstatements in staging area, and implemented various constraints for data consistency.
• DevelopedSQLQueries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Build cubes using SSAS and created reports from Analysis Services using MDX query designer.
• Involved in storage and partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX andSQL.
• Provide analytical support of global supply chain management strategies, goals, and objectives Serve for various projects and reports and collect and analyze information usingSQLQuery tools, and make recommendations to the team.
• Extensively used BI tools like integration service, Reporting Services and Analysis services in MSSQLServer.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and worked on Drill Down and Drill-through reports, Tabular, Matrix, etc.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Used various SSIS transformations like Conditional Split, Multicast, Fuzzy look up etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into Data warehouse.
• Created customized reports using various chart types like Text Tables, Bar, Pie, Tree Maps, Line Charts, Pivot Tables in Excel and Tableau.
• Created cubes with Start schema in SSAS and developed SSRS report based on the cubes.
• Used performance tools likeSQLProfiler, Index Tuning Wizard and Database Engine Tuning Advisor.

Environment: SQLServer 2008 R2, T-SQL, Excel, Microsoft BI, Windows Server 2008, Visual Studio, Query Analyzer, SVN version controlling, Tableau.

Confidential

SQL Developer

Responsibilities:

• Involved in planning and designing database and coordinate with DBA in creating and managing database objects.
• Actively involved in Normalization of database.
• Designed DDL and DML for MSSQLServer 2000.
• Create rules, defaults, tables, views, clustered & non - clustered index, user defined data types, and user defined functions.
• Optimize query performance by creating indexes.
• Involved in writingSQLbatch scripts.
• Write T-SQLstatements for retrieval of data and involved in performance tuning of T-SQL.
• Involved in merging existing databases and designed new data models to meet the requirements and perform daily database backup & restoration and monitor the performance of Database Server.
• Created joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and configuredSQLServer 2000 on development server for designing and testing.

Environment: MSSQLServer, T-SQL, DTS,SQLServer Enterprise Manager,SQLProfiler.

SQL Server Developer

Confidential

Responsibilities:

• Managing Installation, Configuration and Maintenance of MSSQLServer 2005.
• Created and manages schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Participated in re - design and development of back-endSQLServer database, wrote queries, triggers and stored procedure.
• Involved in creating different flow services required for data transformation, creating & validating IS Schema, IS Document types.
• Involved in the configuration of JDBC Adapter using different templates like custom adapters using differentSQLQueries and Stored Procedures.
• Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication.
• Created and running DTS Packages for Import and Export of Heterogeneous Data.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Responsible for unit testing, writing design documents and uploading it to share point server.
• Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Created database administrative job of Security, Backup/recovery, ODBC connections etc. Provided support to the Application developers on the application databases.
• Responsible for creating stored procedures and SSIS packages as part of the ETL process to populate the data marts.

Environment: SQLServer, Windows 2000/XP, MS Access,SQLProfiler, DTS, T-SQL, Query Analyzer, MS Excel.