SUMMARY

• Around 8 years of Experience in Relational Databases, Data Warehousing and Business Intelligence applications design, development and Maintenance of SQL Server Databases, Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
• Experience working on .NET Framework for building UI/Web-based applications using C#, ASP, VB, ADO.NET.
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Expertise in MS SQL Server databases with tools like IndexTuningWizard, SQLProfiler, and WindowsPerformanceMonitor for optimal Performance.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Extraction, Transformation, Loading data from SQL Server, Access, Excel, Flat Files and XML using, SSIS.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in creating SQL server Reports using SSRS 2005/2008.
• Expertise in creating ReportModels for building Ad hoc reports using SSRS.
• Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill-down and Sub reports and formatting them.
• Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS 2005.
• Knowledge and experience in designing, developing and deploying Reports and Dashboards.
• Experience in creating EDI based reports.
• Knowledge of Healthcare standards like HIPAA, HL7 etc.
• Experience in SQL Server Analysis Services (SSAS) CUBE design, development and deploying.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Experience working with Data Architects in design & development of Data Models for reporting.
• Experience in Creating, Modifying Measures, DimensionsAttribute relationships and Hierarchies.
• Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
• Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent.
• Worked in Data Warehouse and Business Intelligence Projects along with the team of Informatica, Talend (ETL), Cognos 10, Impromptu and Powerplay.
• Experience in code optimization and improving efficiency in databases including re-Indexing, updating statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Experience working with Version Control Systems like TFS, Git, SVN for deployment to Dev/QA/UAT/PROD Environments.

TECHNICAL SKILLS

Operating System: Windows 8/7/Vista/XP/2003/2000, Windows Server 2003

Languages: C, T-SQL, PL/SQL

Microsoft Technologies: C#.NET, ASP.NET, VB.NET, ADO.NET

Web Technologies: HTML, XML, DSL, Web Services

RDBMS: MS SQL Server 2008R2/2008/2005, Oracle

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS), Talend, Tableau, Power BI

Development Tools: Visual Studio.NET 2008

Database Query Tools: SQL Server Management Studio (SSMS), Business Intelligence

PROFESSIONAL EXPERIENCE

Confidential, MI

SQL Developer

Responsibilities:

• Development of Pharma Contract Reports using stored procedures, tables, SSIS packages and SQL jobs.
• Experience in creating SSIS packages using proper control and data flow elements.
• Conversion of existing reports based on SQL Server 2008 in the Legacy Data warehouse (LDW) to Talend generated reports in the new Enterprise Data warehouse (EDW).
• Extracting and Loading data into SQL Server Database using SSIS.
• Created stored procedures, functions, views and triggers to retrieve the data from the database.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Migration of Reporting databases to OLAP Enterprise Data Warehouse eventually to create Reporting Data vault.
• Creation of Flat file, Excel and EDI based reports in SQL Server 2008 and Talend.
• Experience in development and QA of EDI 867 Product Transfer and Resale, EDI 852 Inventory reports.
• Developed reports like Patient Status, Drug Dispense and Inventory, Rx Status, Patient Call Log and Invoice reports in SQL Server 2008/SSRS 2008 and Talend.
• Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.
• Generated reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Handle daily Service Now tickets raised by internal teams and issues with customer reports deployed in Production.
• Check the daily status of reports in production and work with Account Managers to help resolve customer report issues with respect to data accuracy and data validation.
• Development of reports and tables with sound understanding and familiarity of HIPAA and PHI Federal regulations.
• Involved in creating the tree view folder structure using C# .NET to handle different reports.
• Involved in resolving data discrepancies with the C# .NET Application developers.
• Development of reports and database object with sound understanding and familiarity of HIPAA and PHI Federal regulations.
• Understanding of disease codes - ICD-9 and ICD-10.
• Research, validate, and create data mappings for reports as per the Business Requirement Documents via MS Excel 2010 and Collibra.
• Worked on development of EDWARD - Enterprise Data Warehouse Analytic Resource Data.
• Experience fixing Reporting Data Vault issues which was built on top of the EDW.
• Developed ETL using SSIS to pull data on a daily basis from OLTP database to OLAP database.
• Create Talend ETL jobs to load the data warehouse databases and data mart databases.
• Extensively used components like tMSSqlInput, tHashoutput, tHashInput, tMap and other components to create Talend jobs.
• Experience fixing issues with Talend job components while ETL and Report development using Talend Studio 5.6.1.
• Fine-tuning of queries, updated the stored procedures to increase efficiency.
• Assist Data Analysts and Business Analysts with creation of Tableau dashboards while integrating Tableau extract engine with Talend ETL.
• Test solutions and resolve issues before moving to Production.
• Work with QA teams for development of UAT testing metrics.
• Worked closely with clients in gathering and analyzing requirements and providing solutions that meet the client’s requirements.
• Involved in full lifecycle of the project from design, development & Testing.
• Used ASP.NET Validation controls to do client-side validations based on the user’s browser.
• Used Master Pages to achieve uniform template design for the entire application.
• Used Tortoise SVN for version control in team environment
• Identified primary keys, foreign keys and enforced not-null and checked constraints in the table and
• Experience working with Git and SVN to manage code development, tracking and deployment on servers.

Environment: MS SQL Server 2012, SQL Server BIDS 2008, Microsoft .NET 4.5, SSRS, SSIS, Visual Studio 2008, C# .NET, Atlassian JIRA, Share Navigator, Collibra, Talend Studio 5.6.1, Automate 11, Git, Service Now, Enav, Tableau

Confidential, Phoenix, AZ

Sr. MSBI Developer

Responsibilities:

• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Migrated DTSX packages from SQL Server 2008 to SQL Server 2012.
• Worked on different kinds of Transformations in SQL Server Integration Services (SSIS) like Slowly changing dimension (SCD’s), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as per the client requirement.
• Implemented Logging and Event Handlers on SSIS packages for trouble shooting.
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for monthly Statements.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Designed SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Involved in designing and developing the GUI Using ASP.net and VB.net.
• Developed business logic (BLL) components using ASP.net for server-side business validations.
• Developed client side scripting functions using JavaScript for validations.
• Operational knowledge of classic ASP programming and JAVA script programming
• Implementation of User Controls and Caching to improve system performance.
• Implementation of page level and general exception handling for the applications.
• Developed Data Access Layer (DAL) using ADO.net.
• Used VSTS for the bug tracking and to track status of the project.
• Extensively used AJAX for partial post backs.
• Design and development of all the modules including the Database design and development using new features in .NET 2.0
• Created Web Forms using ASP.NET, MS Visual Studio .NET
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: MS SQL Server-2012/2008R2/2008, SSIS, SSAS, SSRS, SQL Profiler, Informatica, MS Excel, C#.NET, ASP.Net

Confidential, Anaheim, CA

MSBI Developer

Responsibilities:

• Involved in Normalization of the database and bringing it to 3NF.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created SSIS Packages to migrate slowly changing dimensions.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS)
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS). Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Developed the logic to Capture the Error Rows in the data flow and populate them into an Excel file.
• Involved in ETL Architecture, Developing Source to target data mapping (STDM) document defining transformation logic.
• Building KPI reports for the cubes and optimizing the reports.
• Involved in partitioning of cubes in order to increase the performance of cubes (SSAS).
• Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Created complex reports which involve more number of groupings and multi-value parameters
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Rendered the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Worked on Logical and physical database development (using ER-win, Normalization, Dimension modeling and Enterprise manager).
• Experience working on Talend ETL tool, to develop jobs and scheduled jobs in Talend integration suite.

Environment: MS SQL Server-2008R2/2008, SSIS, SSAS, SSRS, SQL Profiler, Erwin, Talend

Confidential, Harrisburg, PA

SSIS/SSRS Developer

Responsibilities:

• Designed packages using Transformations Sort, Merge, Merge Join, Union, Union ALL, Lookup, Aggregate, OLE DB Command and Derived Column.
• Configured SSIS packages to load data to data warehouse databases, and SSAS cubes.
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Developed forms on share-point to show data from data-sources to Clients and enabling them to edit the data and update the data in the data-sources and allowing inserting data into the data-sources.
• Managed and resolved design issues during development.
• Worked to establish connectivity between VB applications and MS SQL server by using ODBC.
• Involved in Migration of data from Oracle database to SQL server 2005 database using SSIS.
• Created reports on to Share-Point and Report Server and set the data-driven subscriptions for these reports.
• Deployed generated reports of each quarter onto the Report Server to access it through browser.
• Created custom and standard reports using Crystal Reports.
• Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals and alerting.
• Designed and developed Data Warehouses, Data marts using Multi-dimensional models such as Star Schema and Snow Flake Schema for developing cubes.
• Generated reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS.
• Formatted the SSRS reports using the Global variables, expressions and Functions.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Extensive experience in developing User Interface (UI) and XAML for the better look and feel of the desktop-based application.
• Involve in coding front end client using UI Framework and WCF.
• Used Master Pages to achieve uniform template design for the entire application.
• Used VB.NET to develop code behind logic, business tier and SQL Server 2005 for data tier.
• Used Tortoise SVN for version control in team environment
• Maintained the consistency of data by performing Data Profiling and Data Cleansing.
• Involved in developing Life Cycle using Agile Methodology.
• Created the documents and packages in Team Foundation Server as a version control.

Environment: SQL Server 2008R2/2008, SSIS, SSAS, C#, Erwin, Visual Studio, VB, Visual Basic.net, SAP BO, Oracle PL/SQL

Confidential, AL

SQL Server /SSRS Developer

Responsibilities:

• Generated Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps using SSRS.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Managed Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
• Involved in developing TYPE-1 and TYPE-2 Dimensions using SSIS.
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Generated Sub-Reports, Drill down-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Deployed reports in to Report Manager.
• Created Ad-Hoc reports using Report Builder.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.

Environment: MS SQL Server 2008R2/2008, SSRS, Visual Studio 2008, MS-Access, MS-Excel

Confidential

SQL Server /SSIS Developer

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Involved in designing of Conceptual Logical Model and Physical Model using ERWIN.
• Involved in Migration of few objects from SQL Server 2000 to SQL Server 2005 using Migration Wizard.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Wrote Ad-Hoc T-SQL queries for analysis purposes.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS-DTS packages for executing the required ETL tasks. Created the Jobs and scheduled for daily running.
• Developed business and data access layer using C# and ADO.Net.
• Was actively involved in UI Design, Classic ASP Pages and Coding ASP Pages using C#.
• Designed Custom Web Control in the form of Composite and Derived Controls.
• Designed and Implemented User Interface Layer using ASP Web Forms.
• Developed web forms and Web server controls using ASP.
• Provided technical support to client by handling their queries and dealing with their requests in Classic ASP.
• Implemented N-Tier Architecture and integrated the UI with Data base for data retrieval and manipulation using ADO.NET data objects and ADO.NET Entity Framework.
• Created reports from database onto excel spread sheet using DTS.
• DTS Packages created to export and import data from CSV files, text files and Excel files.
• Involved in creating maintenance plans in SQL Agent to back up the database.
• Worked with development teams in the design of physical databases and in modification.

Environment: SQL Server 2005, Windows 2000 Server, SQL Profiler, DTS, Query Analyzer, Visual Basic, Enterprise Manager.