SUMMARY:

• Over 8+ years of Data warehousing experience with Microsoft SQL Server 2012/2008/2005, SSIS/SSRS/SSAS, OLTP and OLAP.
• Experience working with RDBMS systems like SQL Server, Oracle, DB2 and Access.
• Experience in developing the applications using T - SQL Programming.
• Hands on experience in creating ETL packages using SQL Server Integration Services (SSIS).
• Extensive experience in the development of reports using SQL Server Reporting Services (SSRS).
• Designed reports using Report Designer, Report Builder, and Report Manager.
• Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix and parameterized reports.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Good knowledge in optimizing queries using MDX and DMX.
• Experience in automating processes by creating jobs, and error reporting using Alerts.
• Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort, and Derived Column for cleaning bad data, validating data.
• Experience in designing Database Models using MS Visio and ER-Win.
• Expertise in generating reports using Business Objects 6.5/XI and Crystal Reports.
• Solid experience in creating tables, views, stored procedures, triggers, functions and indexes.
• Expert in Extracting and Transforming data using SSIS in SQL Server 2012/2008/2005, DTS in SQL Server 2000, Bulk Insert and BCP.
• Experience in the Software development life cycle methodologies.
• Excellent in Transforming Logical Database designs into Physical Databases.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in monitoring database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS:

Databases: Microsoft SQL SERVER 2012/2008 R 2/2008/2005/2000, ORACLE, DB2

Reporting Packages: SQL Server Reporting Services, Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel

Database Utilities: Business Intelligence Development Studio (BIDS), SQL Server Data tools, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), Data Transformation Services(DTS)

Operating System: Windows 2012 R2/2008 R2/2008/2000, UNIX, Linux

Tools:: MS Visual Studio, TFS,MS Visio, Erwin

WORK EXPERIENCE:

Sr. SQL Server BI Developer

Confidential, Orlando, FL

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• DDL Scripts for generating Tables, Views, Functions.
• Analyzed and designed software and database solutions.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Configured Reporting Services in SQL Server 2005.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Created Views to reduce database complexities for the end users.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created checks and constraints to maintain data integrity.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Windows2003 Advanced Server, MS SQL Server 2000/2005, T-SQL, Visual Studio 2005,Oracle, SSRS, SSIS, Erwin.

Sr.SQL/ BI Developer/ T-SQL Developer

Confidential, Farmington, CT

Responsibilities:

• Involved in Database Design, Schemas, Tables, Views and Indexes.
• Backend database development in MS SQL Server, writing complex Ad-Hoc Queries, Stored Procedures, Views, Triggers, Cursors and UDFs.
• Performed Database code Migration from SQL Server2005 to 2008 in SDLC environment using Bridging Scripts, Column Mapping Tool and SourceControlExplorer in Visual Source Safe (VSS) and finally passing all Triggers, Views under Unit Testing for validating data Insert, Update and Delete.
• Experience in SQL Joins, Sub Queries, Tracing and Performance Tuning.
• Extensive use of Triggers to implement business logic and for auditing changes to critical Tables in the Database.
• Involved in development of Extracting, Transforming and Loading (ETL), maintain and support the enterprise Data Warehouse system and corresponding Data marts.
• Experience with SSIS performance tuning using Counters, Error Handling, and Event Handling, re-running of failed SSIS packages using Checkpoints and Scripting with Active-X and VB.NET in SSIS.
• Experience in SSIS script task, look up transformations and data flow tasks using T-SQL and Visual Basic (VB) scripts.
• Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services

Environment: MS SQL Server 2000/2008, T-SQL, Windows XP 2000, MS Visio, MS Projects.

Sr. SQL Server BI Developer

Confidential, Omaha, Nebraska

Responsibilities:

• Worked extensively on FACETS 5.01 data base and gained good knowledge on FACETS data model.
• Created data mappings to load and transform the data from XML, Flat files, and CSV files. Extracted data into delimited files and fixed width files
• Developed ETL packages using multiple data sources and data destinations (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS transformations.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Worked on EDI 837 and 835 files.
• Worked on custom claim table’s data modeling.
• Modified Korn and Bourne shell scripts in order to automate administration tasks like customizing user environment and performance monitoring..
• Performance Management & Tuning of AIX /UNIX Kernel.
• Insurance Claims Data warehouse LOGICAL AND PHYSICAL MODEL (Facts and Dimensions).
• Extracting Claims, Codes, Provider and Pharmacy data from various sources and Creating SQL scripts for various transformation rules.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Published Workbooks and Dashboards to the Tableau server.
• Worked with appropriate development and technical support teams to triage, assess and solution.
• Created groups and users in Tableau server.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Successfully migrated from SQL Server 2008 to 2012 and also to 2014 on Development/Testing/production Environment.
• Assessing project driving factors through AJILE ( sprint and scrum ) sessions with MIS ETL Team
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Design the required Informatica mappings and assign to team members for development.
• Defined standards required for entire development process, especially for Informatica mappings.
• Assessing reporting requirements to Epic Users through necessary investigations, analysis and evaluation to generate desired reports. Evaluating requests for completeness and working with Epic User if needed to finalize the request
• Extensively worked with SVN tortoise and TFS to keep track of all changes made in the project.
• Provided documentation about database/data warehouse structures and Updated functional specification, technical design documents and Unit test cases.
• Created and deployed reports using SQL Server Reporting Services 2008R2 (SSRS).
• Created Parameterized, Ad hoc and drill down reports using Report Designer.
• Used various report items like tables, sub report and charts to develop the reports in SSRS 2008R2.

Environment: FACETS 5.01, MS SQL Server 2008/2008 R2,Informatica power center, Korn shell, Bash Scripting OLAP, ROLAP, Visual Studio 2008/2010, Windows 2007, T-SQL, XML, SSRS, SSIS

Sr. SQL Server BI Developer

Confidential, Sunrise, FL

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Created SQL joins, Sub queries, tracing and Performance Tuning for better running of queries.
• Designed different type of reports including: Tabular, Matrix (cross Tab report), List items, Charts and Linked reports.
• Created and designed reports based on query parameters and Report parameters.
• Created nested Grouping, sorting columns and writing expressions according to the business requirements.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions to migrate data from staging to production environment
• Modified existing stored procedures, functions using joins following SQL Standards to enhance the performance of the reports.
• Experience with Indexing, normalization and query optimization.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse Worked on SSIS script task look up transformations and data flow tasks using T- SQL .
• Generated Custom ETL scripts using SSIS, develops and unit test SSIS load processes for performance check.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

Environment: SQL Server 2012 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), OLAP, OLTP, Performance Point Server, ETL, Enterprise manager, Windows Server 2008R2.

Sr. SQL Server BI Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL joins and other statements for various applications.
• Performance tuning of the stored procedures, User defined functions and long running queries.
• Automated the ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice versa using SSIS.
• Analyzed and designed business processes as per the business requirements with SSRS reports
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
• Extensively used Ultra-Edit to verify the text file provided by employer/agency and keep trace of files provided by employer/agency
• Transformed data from text file to SQL server using OLE Automation Objects
• Created various dynamic reports using SSRS and Crystal reports.
• Worked with AS/400, Rumba, Fast Teller, Fast Sales and company Intranet applications.
• Migration of data from one Netezza host to another Netezza host using NzMigrte utility.
• Involved in Oozie workflows creation to schedule the sqoop jobs to load the data from Hive views to Netezza tables.
• Structure tables in Netezza to get collocations during query executions, make use of stats, zone
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS) and used the SSAS as source for generating parameterized reports in SSRS.
• Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage and also using SSIS package.
• Analyze, triage and troubleshoot alarms received by internal and external monitoring

Environment: MS SQL Server 2005/2008, SAS/SQL, SCCM 2012, OLAP, ROLAP, Python, Python SDKVisual Studio 2005/2008, Windows 2007, Windows XP, T-SQL, XML, Crystal Reports, SSAS, SSRS, SSIS.

Junior SQL Developer

Confidential

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server2000.
• Developed Database Triggers to enforce Data integrity and Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Defined relationship between tables and enforced referential integrity.
• Involved in Implementation of Database design and Administration of SQL based database.
• Established connectivity to database and monitored systems performances.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: SQL Server 2000, Windows server 2003, Enterprise Manager, SQL Profiler, SQL Query Analyzer, DTS, T-SQL.