PROFESSIONAL SUMMARY:

• 8+ years of demonstrated success working with large - scale database enterprise applications.
• Expert in MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 suite of products like SSRS, SSAS, and SSIS.
• Sound knowledge in Data integration using ETL tools such as SSIS (Microsoft BIDS) and Informatica.
• Extensive knowledge in T-SQL queries (DDL and DML).
• Expertise in designing SSIS packages to transform data between databases and external data sources.
• Extensive experiences in developing Tables, Stored Procedures,Views, Triggers, Pivot tables using Excel, Joins, User- defined functionsand Complex Queries
• Experience in MSBI suite of products - Power View, Power Pivot, Power Query, Power Map and Crystal reports from Cubes, MDX query/scripts and MDS (master data services) with data mining.
• Experience in migrating data from heterogeneous database like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using SSIS / DTS.
• Perform Integration, testing and implementation of BizTalk solutions.
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) and OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2000/ 2005/2008/2008 R2/2012.
• Experience in MSBI suite of products such as Power View, Power Pivot, Power Query, Power Map and Crystal reports from Cubes, MDX query/scripts and MDS (master data services) with data mining.
• Conversant with Teradata, Sybase and migration to the SQL Server.
• Good understanding of POS products, applications and analytical skills.
• Experience in developing Software Development Life Cycle using Agile Methodology.
• Proficient with Reporting tools - SSRS and Tableau.
• Experience in Designing DataMart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling.
• Worked with DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Extensive knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Created and managed Indexes and optimized queries using Query Execution Plan.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Advanced level creation of Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, and User defined data types, Cursors and Indexes using T-SQL.
• Experience in using T-SQL in SQL Server 2014/2 R2 and previous platforms.
• Implemented complex business logic into database design and maintained the referential integrity.
• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Reporting Services (SSRS 2005/2008/2008 R2)
• Experienceingenerating on-demand and scheduledreportsfor business analysis in SSRS.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports, Matrix reports and Charts.
• Have experience in Crystal reports and power BI.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
• Integration of SSRS Reports using various web parts into SharePoint and various delivery mechanisms.
• Extensive knowledge in ETL Process & Progressive knowledge in using DTS/ETL/SSIS utilities.
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Involved in migration of DTS/ETL Packages (2000) to SSIS (2005/2008) and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, AS400, and DB2 to MS SQL Server by using Import Export Wizard, DTS/ETL SSIS, and BCP & Bulk Insert utilities.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Solid Knowledge in developing cubes using Partitions, KPIs, and Perspectives, slow moving dimensions; created various user roles.
• Sound experience and understanding of SSAS, OLAP cubes and Architecture.
• Developed and deployed OLAP cubes using SQL Server Analysis Services (SSAS) 2012/2008R 2/2008/2005.
• Experience in developing physical database architecture using ERwin Data Modeler and MS Visio 2003/2007.
• Experience in designing DataMart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Dashboard pages in Performance Point Server that use different types of web parts and excel services for reports.

TECHNICAL SKILLS:

Databases: SQL Server 2014/2012, 2008 R2, 2008, 2005 & 2000 & 7.0, MS-Access 2000/2003/2007 , MySQL, Postgres, Amazon Redshift

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Profiler, SSIS, SSAS, SSRS, DTS/ETL/Informatica, AZURE,CRM,BIZTALK,BCP, Business Intelligence Studio, Ad-hoc reports, Power BI.

Languages: C, C++, VB, C#, XHTML, PHP, T-SQL, Dynamic SQL, MDX, XML.

OS: Windows 2010, 2007, 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP.

Web Servers: IIS 5.0, Apache, Tomcat, SharePoint 2007

Other Tools: Erwin, Microsoft Visual Studio 2016/ 2014/2012/2008 , Microsoft Visio, Microsoft Visual Source Safe, MS-Front Page, FTP, MS-Outlook Express TFS, FACETS 5.01 and SVN tortoise.

Architecture: Relational DBMS, Client: Server Architecture, OLAP, ROLAP, MOLAP and OLTP

PROFESSIONAL EXPERIENCE:

Confidential, Orange, CA

BI /ETL SQL Developer

Responsibilities:

• Involved in database development and creating SQL scripts. Wrote complex T-SQL queries to support business needs.
• Involved in the Requirement Study, TDD Creation, UI Design, Development, Implementation, Code Review, Validation and Testing, Deployment and client interactions.
• Engaged in Agile methodology, sprint meetings and every day standups.
• Worked closely with customers and IT management and staff to provide application development and production support.
• Helped to support Application suit within Quotit for open enrollment period, done some UAT testing for the applications.
• Responsible for Data Migration of health insurance (Action) from Oracle to SQL server 2012 using SSIS via Microsoft management studio 2012 and writing some reports using Microsoft SQL server Business Intelligence Studio.
• Used MSRS harvest tool to check-in and check-out of the code or rdl file to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Defined High Level Data Architecture for ETL and BI Solutions and Framework Design, Prototyping, ETL Loading Strategy Definition, Data Stage, Data Governance and RDBMS standards definition and enforcement, Definition of Data stage Best Practices and Coding Standards.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task.
• Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
• Created Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database
• Analyzed SQL data, identifying issues, and modifying the SQL scripts to fix the issues.
• Review every day applications to ensure they are accepted.
• Tuned and optimized SQL Queries using execution plan and profiler.
• Used SOAP UI API calls, T-SQL to run daily tasks and provide daily report to business and IT at the end of each day.

Environment: T-SQL, MS SQL server 2012, 2008R2,SSIS,SSRS, SSDT, Soap UI, Power BI, VB.NET, Excel

Confidential, Wilmington, DE

MS SQL BI Developer/ETL

Responsibilities:

• Involved in installation and configuration of MS SQL Server 2012/2014.
• Lead in database development and design using OLTP and OLAP systems (SSIS) using Data tools 2010. Wrote complex T-SQL queries to support reporting needs, and performed systems/data analysis functions.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created DTS/ETL package to schedule the jobs for batch processing.
• Worked closely with customers and IT management and staff to provide application development and production support. Designed, coded, tested, debugged and documented computer equipment capacity and limitations, software alternatives, operating time and desired results.
• Conducted research and evaluated alternative solutions; recommended the most efficient and cost effective application programming solution.
• Coded new or modified programs, reused existing code through program development software alternatives and/or integrates purchased solutions.
• Lead the team by Analysed, troubleshot and resolved complex production application defects.
• Identified root cause, devised and implemented permanent solutions to recurring defects.
• Monitored production jobs and environments, performed in-depth data and systems analysis.
• Devised or modified programs to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports using SSRS.
• Used cascaded parameters to generate a report from two different Data Sets using Report Builder 3.0.
• Worked on Crystal reports, Dashboards and most of the reporting needed by the business.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Analysed business user needs and provided optimal technical solutions.
• Coded new programs, enhance existing programs and/or integrate packaged vendor solutions with existing systems.
• Implemented Data model structures according to the requirement.
• Documented, tested (unit and integration), implemented and provided on-going support for the applications.
• Followed SDLC standards, source code management, and release management procedures.
• Provided rotational weekly 24 X 7 on-call support for critical applications.
• Hands-on Smart Solve CAPA, verified that CAPA system procedure(s) that address the requirements of the quality, actions were effective, verified or validated.
• Had some opportunity to learn and support new technologies, Worked with Azure application, UNIX as well.

Environment: T-SQL, MS SQL server 2014, 2012, 2008R2, SSDT, SSIS, SSRS, Tableau, Crystal reports, VB.NET, UNIX, Excel

Confidential, Richmond, VA

MS SQL BI Developer

Responsibilities:

• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
• Involved in installation and configuration of MS SQL Server 2008/2012.
• Involved in designing database and perform forward engineering, data migration, data modelling from conceptual data model to Logical and physical data model using Erwin 7.2 data modeller tool.
• Created staging and consolidation tables form logical models.
• Worked directly with the Azure Product team in tracking and resolving defects in the beta Azure offerings.
• Generated reports using the Crystal Reports and Reporting Services 2008/2012, Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008/2012.
• Used SQL Server 2014 for supporting old codes.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Created indexes, Constraints and rules on database objects for optimization.
• Migrated some Crystal reports to SSRS reports manually
• Extensive experiences in developing Tables, Stored Procedures,Views, Triggers, Pivot tables using Excel, Joins, User- defined functionsand Complex Queries on SQL Server 2008/2012.
• Populate or refresh Teradata tables using Fast load & Fast export utilities for user Acceptance testing and loading history data into Teradata.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Wrote complex Queries, Triggers, User-defined functions as per the business requirements.
• Involved in migrating data from MS SQL server 2000/2005 database to MS SQL server 2005/2008 database.
• Extracted data using Azure services and build Data Sync job on Windows Azure to synchronize data from SQL 2012 databases to SQL Azure.
• Experience in Disaster Recovery Planning, Execution and Testing at remote side to support the admin work.
• Performing administrative tasks like database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. .
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Used Amazon Web Services AWS cloud storage tools to process web analytics data.
• Used MDX to create calculated members in the cube.
• Operational and summary reporting framework design and development (MDX, PowerPivot, DAX, SSRS, ProClarity, Crystal Reports)
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008 Analysis Services.
• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Drill down, Drill through, Sub reports in SSRS.

Environment: MS SQL Server 2014/2012/2008 R2, T-SQL, QNXT, .NET, C#, SSRS, SSIS, SSAS, MS Performance Point Server 2007, MS Share Point Server, AWS Redshift, Power BI, Azure, MS Access and Excel.

Confidential, Houston, TX

MS SQL BI Server Developer

Responsibilities:

• Vested with Logical and Physical Data modelling.
• Wrote stored procedures, Triggers, User-defined Functions, and Views.
• Created SSIS packages to load the Enterprise Data Warehouse.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Designed and developed Databases for different systems and Data was populated by SSIS Packages.
• Implemented table partitioning on tables in excess of 300 GB increasing load performance by more than 800 percent and report performance by more than 60 percent.
• Experience in the use of adapters to simplify integration to line of business applications using BizTalk.
• Worked on administration console for deployment, monitoring and operations of solutions on BizTalk servers in environment.
• Business activity monitoring (BAM), which allows a dashboard aggregated (PivotTable) view on how the business processes are performing and how messages are processed by using BizTalk.
• Created indexes and proper re-indexing for intensive OLTP system to ensure best performance.
• Worked with SQL 2008 Advanced features like CTE’s, Except, Intersect, Pivot and Un-pivot.
• Performed ongoing monitoring and refinement of database queries and ETL programs.
• Create database objects including tables, triggers, views, stored procedures, indexes, defaults and rules.
• Set database access privileges for different users and user groups.
• Used various Control Flow tasks such as Execute SQL Task, Script Task and Data Flow tasks such as Lookup, Derived column, Script Component etc.
• Other reports where created for managers for strategic planning purposes and for end-users.
• Responsible for maintaining database more than 1TB in respect to performance backup times san architecture and archiving data.
• Involved in performance tuning to optimize SQL queries using query analyser.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and optimized the procedures and triggers to be used in production.
• Performed query optimization and checked performance tuning
• Connected Tableau server with share-point portal which is extracted from Oracle server and setup auto refresh feature.
• Purchasing, setting up and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Developed packages using containers such as sequence containers, For Each Loop and For Loop containers.
• Performed Error Handling using Event Handlers and used in built Error Description to capture redirected errors.
• Experienced in working with SQL 2008/2012, SSIS, Reporting and Analysis Services.
• Supported the Director of Business Information in their interactions with key stakeholders to define, design and develop critical reporting needs using SQL Server Reporting Services 2008/2012.
• Developed Complex Packages to load data into Stage, ODS and Data Ware House systems.
• Experience in Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery.
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Reports are uploaded to Azure cloud services for the future use.
• Create a Virtual Network on Windows Azure to connect all the servers.
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
• Integrated Excel Services and SSRS Reports to SharePoint for BI reporting.

Environment: MS SQL Server 2012/2008/2005 , VS 2012/2008/2005 , Oracle, SQL Server Reporting Services (SSRS 2008/2005), Micro Strategy, SQL Server Integration Services (SSIS), BIZTALK, Business Intelligence Development Studio (BIDS), Tableau, Tableau Server, Azure, T-SQL, PL/SQL, Microsoft Office SharePoint Server (MOSS) 2010, Performance Point Server 2010, Visual Source Team Foundation Server (VSTS) 2012.

Confidential, Worcester, MA

MS SQL Server/SSIS/SSRS/ BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Researchfor technical approach to install, configure Performance Point andPowerPivot services in SharePoint 2010.
• Created joins and sub-queries for complex queries involving multiple tables.
• Done SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Proficient in writing MDX query and good knowledge of all MDX Functions
• Used advanced features of T-SQL to design and tune T-SQL to interface the database and other applications.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and SCD.
• Design SSIS packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Cascading reports, Drill down reports.
• Involved in Performance tuning the SQL Server Queries used in SSRS Report and Report Snapshots.
• Created user groups in Report Manager for limited access to the end users in SSRS.
• Developed Ad Hoc Report Model for specific users is SSRS.
• Created Reports that involve Dynamic Grouping and Sorting to provide information and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Migrated Tableau work and created new reports representing the old data onto SSRS.
• Generated Sub-Reports, Cross-tab, and Drill down, Drill through reports and parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: MS SQL Server 2008R2, T-SQL, SSIS 2008, SSRS 2008, TFS 2010, Advanced Server, SSMS, Erwin v7.2, ASP.Net, Share Point 2010, Power Pivots, C#.

Confidential

SQL Server/BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solution for different types of information consumers.
• Developed complex T-SQL code such as Stored Procedures, functions, Indexes and Views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from Mainframe staging database.
• Created SSIS package to load data from Flat files, DB2 by using Lookup, Derived Columns, Data conversions and Condition Split transformations.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load Data to Mainframes tagging database and Marketing DataMart.
• Developed complex T-SQL code such as Stored Procedures, functions, Indexes and views for the application.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing SSIS packages on defined intervals in SQL Server Agent.

Environment: T-SQL, MS SQL server, SSIS, SQL Profiler and T-SQL, Windows 2007 and Visual Studio 2010, Microsoft Office, DB2.