SUMMARY

• 10+ years of experience in Business Intelligence Using Microsoft SQL Server 2012/2008/2005 , Teradata and Oracle.
• Currently working as a Data Conversion/SSIS/ETL Developer at Confidential Consulting LLP for the State of Louisiana government in the department of children and family services (DCFS) project.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing,, testing, and implementation.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SQL Server Integration Services 2012/2008/2005 (SSIS).
• Expert in developing Cubes on SSAS using SQL Server 2008/2012.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in creating partitions and designed various storage modes to increase the performance of cubes using SQL Server Analysis Services 2008/2005 (SSAS)
• Expert in calculating measures and dimension members using Multi Dimensional Expression (MDX).
• Expert in writing DAX for writing custom calculations in power pivot MS Excel reporting
• Performed complex SQL, PL/SQL procedures and MDX Queries and generated reports.
• Experienced working on OLAP database development including KPIs, Data Mining.
• Expertise in designing complex reports like Dashboard Reports, Drill - Down Reports, Parameterized Reports, Cascaded Reports and Sub Reports using SQL Server Reporting Services 2008/2005/2000 (SSRS) based on client requirement.
• Expert in deploying the SSRS reports on Report Server.
• Expert in creating complex Stored Procedures, User Defined Functions, DDL/DML Triggers, Views, Cursors and Indexes to facilitate efficient data manipulation and data integrity in Teradata.
• Experience on High Availability/Disaster Recovery (HADR) solutions, Failover Clusters and Always on High Availability Groups, Replication, Log Shipping and Mirroring.
• Building the MS Dynamics CRM forms, screens, and views, as well as workflows and reports around the customer needs for an interface.
• Experience in interacting with MS CRM database through the use of web service methods.
• Manage the delivery of CRM configuration, custom assembly development, integration code and data migration scripts of the Microsoft Dynamics CRM-based project.
• Testing the Web Applications manually and identify the application and database issues.
• Identify the application level issues and log the defects using JIRA as the Defect tracking tool.
• Logged all type of objects in JIRA from the requirement specification issues, mapping documentation defect and database issues.

TECHNICAL SKILLS

• SQL Server 2012/2008/2005 , MS SQL Analysis Services, MS SQL Integration Services, MS SQL Reporting Services, Power Pivot, XMLA, T-SQL/PL SQL, MDX, JIRA,.NET Framework, C#, PowerShell and Teradata.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SQL BI Developer

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Expert in creating Star schema cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Timely Basis of code check ins using Team Foundation Server for the SSRS Reports.
• Performed troubleshooting of client CRM issues and maintained documentation of all reported issues.
• Worked closely with clients to understand CRM application enhancement needs.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: Tableau Server 7.0/8.0, Tableau Desktop 8.1, SQL Server, Microsoft CRM 2015, JIRA,MS SQL Server 2008, T-SQL, SQL Server 2008, SQL BI Suite (SSIS, SSRS) /DBA, Oracle 11g, JIRA, Report Builder.

Confidential, Mechanicsburg, PA

SQL BI Developer

Responsibilities:

• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs, SIT, UAT, Data Reconciliation and validation.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column, Data conversions, Merge, OLEDB Command, script task components.
• Deployment of SSIS packages to the conversion server and creates and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.
• Developed data reconciliation SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business. Maintained ETL functional specifications, test plans and data for data conversions. Automated the data reconciliation process to minimize the developer involvement in validating production migrations.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Extracted history data from the flat files onto more than 140 SSIS packages by deploying them to different SQL Instances using Integration services catalog and created SQL agent jobs.
• Development of SSIS packages during Conversion, Unit Testing, Defect resolution in the Testing Phases of the project.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Extract Transform Load (ETL) development Using SQL server 2008, SQL 2008 Integration Services(SSIS).
• Collected existing infrastructure information including Active Directory, SQL server, Reporting Server instance for implementation of MS Dynamics CRM 2015 system.
• Building the CRM forms, screens, and views, as well as workflows and reports around the customer, needs for an interface.
• Created SSRS Reports and deployed on the report server and scheduled the reports using subscriptions and created jobs to deploy the reports to a specific location after every Release.
• Testing the Application before moving the code to the higher environments to reduce the defect percentage rate.
• Involved in Resolving the Defects from the Defect Tracking Tool JIRA in all the environments from STAGING, UAT and PROD.

Environment: MS SQL Server2005/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Dynamics CRM 2011, CRM SDK,MS Visual Studio.NET# 2008, Microsoft TFS(Team Foundation Server), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential, Dallas, TX

SQL Developer SSIS/SSRS

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Designing Reports using Tableau on a small data warehouse environment.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Three-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Created and Migrated Partially Contained Databases within Always On Availability Groups.

Environment: SQL Server 2012 Enterprise, BIDS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS), Clustering, Always On, Mirroring, Replication.

Confidential, Montvale, NJ

SQL BI Developer SSIS/SSRS

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Environment: SQL Server 2012 Enterprise, BIDS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS)

Confidential, Greensboro, NC

SQL Developer

Responsibilities:

• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Migrated legacy database and spreadsheets (Access/Excel) to SQL Server 2000 using Data Transformation Services (DTS) and T-SQL scripts.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server, transform and load it into destination.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Design and develop SSIS packages, stored procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Designed and implemented Disaster Recovery Procedures like Log Shipping and mirroring between production and DR servers.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Involved in writing MDX queries and performance optimization of the SSAS cubes
• Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services (SSAS).

Environment: Visual Studio 2008,2012 SSAS, SSRS, SSIS, Teradata, oracle, Power Pivot, SharePoint, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP.

Confidential, Irving, TX

MS BI Developer SSAS/Teradata

Responsibilities:

• Principle responsibility is to solve complex business problems by designing, implementing, maintaining and monitoring multi-dimensional cubes using SQL Server Analysis Services (SSAS).
• Developed Web forms in ASP.net with VB.net and C#.
• Designed MOLAP cubes making use of Star and Snowflake Schemas.
• Customization of a third party tool that was used for developing the application.
• Interacted with end-users in requirement gathering sessions, use case analysis, report layout design.
• Used Calculated Member Builder to create custom measures.
• Designed and developed SQL Server Integration Services 2008/2005/2000 SSIS Packages to automate the cube processing.
• Deploying cubes and reporting services reports to Production servers generated by the offshore team.
• Writing SQL Server Stored procedures/complex queries to retrieve data from Teradata
• Writing MDX queries to generate OLAP reports.
• Writing DAX queries to generate Excel and Drill to detail reports. Also created power pivot reporting from Analysis Services tabular model.
• Created various complex reports like Dashboard, Drill Through, parameterized reports, Matrix and chart reports according to user specifications.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to end users and analysts to be reviewed in Excel Sheets.
• Writing SSIS packages to load data into Facts and confirmed dim tables to build cubes.
• Extensively worked with SQL Server Integration Services 2008/2005/2000 SSIS to created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Multicast and Derived Column.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Triggers, Stored Procedure, and Constraints.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Environment: SQL Server 2012 SSIS, SSAS, SSRS, Teradata, Oracle, Visual Studio 2005, Windows Enterprise Server 2003, ADO.NET, Visual Source Safe, XML, HTML, Erwin.