SUMMARY

• 8 years of experience in Software analysis, design and development in Client/Server systems, Data warehousing and Business Intelligence applications.
• Extensive experience in design, development and Maintenance of Database Applications on SQL Server 2012, 2008, 2005.
• Highly experienced in all aspects of SDLC such as requirement analysis, design, development, testing, implementation, deployment & maintenance of Projects.
• Hands on Experience Integration Services (SSIS) and Reporting Services (SSRS).
• Experience in Extraction Transform Loading (ETL) using DTS and SSIS 2012 and 2008 R2.
• Extensively worked on Reporting Services - SSRS 2012/2008 to generate reports in excel, .cvs formats.
• Experience working in creating Store Procedures in SSMS 2012/2008.
• Hands on creating packages with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and EventHandlers, ErrorHandlers etc.
• Experience in creating Jobs, Alerts, SQL Mail Agent and schedule DTS/SSIS Packages.
• Expertise on using ETL - Data Extraction, Transformation, Loading tools with heterogeneous sources like Oracle, DB2 and SQL Server using SSIS 2012/ 2008.
• Thorough understanding of Kimball’s’ theory, KPIs, Perspectives, Translations and SQL 2008R2 architecture.
• SQL Server 2005/2008/2012 RDBMS database development including T-SQL programming.
• Knowledge in Data modeling using Erwin and design Star and Snowflake schemas.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals.
• Hands on working with Informatica Power Center 9.1 ETL Tool.
• Good Experience on Scheduler Tools like Tidal, Control-M.
• Worked on SQL BI solution integration with Microsoft share point server.
• Worked on source safe, version controlling- Rational Clear Case, Tortoise-SVN
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008, SQL Server 2005, Access, Oracle 8i/9i/10g, MySQL, Data warehouse.

Database Tools: SQL Server Management Studio, Data Transformation Services (DTS), SQL Integration Services SSIS, SQL CMD, Informatica Power Center 9.1, Toad 10.1.1, Facets 5.01

Languages: T-SQL, MY SQL,C, C++, PL/SQL, C#.Net

Reporting Tools: SQL Server Reporting Services (SSRS 2012/2008)

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server, JIRA v6.3.6

Operating Systems: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0Windows 7/vista/XP/98/95.

PROFESSIONAL EXPERIENCE

Confidential - Virginia Beach, VA

SSRS Report Developer

Responsibilities:

• Interacted with Business Analysts in understanding the requirements, solving issues and making the changes as required.
• Worked on different markets - New York, Louisiana, Georgia, Wisconsin, California and on different types of reports - Claims, Providers and Members.
• Worked on complex stored procedures having variety of logics as per the business requirements and provide them the Adhoc file.
• Extensively hands on experience using SSMS 2012 and SSRS 2012.
• Used Facets Explorer 5.01 to view the tables, Columns and do the data mapping.
• Created simple SSIS packages to get the Data load and Create Tidal Jobs and Schedule it.
• Developed RDLs in SSRS using various expressions, Parameters and Formatting.
• Worked on documentation- Create BOIP Forms (Back out Implementation Plan), deployment scripts and command scripts, Logs, SSRS Form related to CNR.
• Involved in Performance Tuning of SQL Stored Procedures developed.
• Used Tortoise SVN for Version Control and maintain all the Code developed on it.
• Involved in all the meetings with BA’s, Leads for BRD review, code review.
• Worked on existing codes for a modification and generate reports on the new requirements.
• Constant communication with the DBA’s, BA’s, Leads to move the CNR from Development to Production.
• Use JIRA for CNR status tracking and moving the CNR to UAT.
• Maintained internal websites for a task assigned - Production Report List, ER task Link, Reporting Servers.
• Unit testing the data in the reports before sending the Adhoc to the business owners.
• Create Data Driven Subscriptions for the reports based on the State needs - Annually, Monthly or On Demand.
• Give Know Transition to the team members on the process and SDLC process.
• Handling new reports as well as working on existing reports and make sure deliverable is on time.

Environment: SQL Server Management Studio 2012, SQL, T-SQL, CISCO Tidal Enterprise Scheduler 6.1.0, Tortoise SVN 1.8.2, JIRA v6.3.6, SQL Server Reporting Services 2012, Facets 5.01

Confidential - Virginia Beach, VA

SQL Programmer Analyst

Responsibilities:

• Interacted with business users in collecting the requirements, solving issues and making changes as required.
• Worked on scripts for creating tables, views and stored procedures in SSMS 2008.
• Created Tidal jobs.
• Used CTU (CNR Testing Utility) tool to deploy code to QA environment.
• Worked on creating BOIP (Back out Implementation Plan), deployment scripts and command scripts related to CNR.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and loaded into SQL server.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Worked on Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Multicast, Data conversion, Merge Join Conditional split, SQL task, Script task and Send Mail task etc.
• Developed packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Involved in Performance Tuning of SQL Stored Procedures developed.
• Also worked on enhancements to the existing codes.

Environment: Oracle 11g, SQL Server 2008 R2, SQL, T-SQL, Tidal Enterprise Scheduler 6.1.0, Tortoise SVN 1.7.13, CTU (CNR Testing Utility), TOAD 10.1.1

Confidential - Columbus, OH

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in daily loads (Full & Incremental) into Staging areas, troubleshooting process, issues and errors using SQL SSIS 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Developed a High level dashboard using SSRS 2008.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Involved in creating report models and applying row level security filters for report model.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Rochester Hills, MI

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Interacted with business users in collecting the requirements, solving issues and making changes as required.
• Created database objects like tables, indexes, stored procedures, views, user defined functions, cursors and triggers.
• Used temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created complex packages to perform the ETL to load the Dimension Tables using SSIS.
• Involved in performance tuning of queries and SSIS packages which increases the performance and runs faster.
• Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Involved in testing the performance of SSIS packages over different servers in collaboration with platform labs.
• Used Event Handlers to handle errors in the packages.
• Deployed the SSIS Packages from development server to production server.
• Created SSRS reports by Report designer for the users and deployed onto the report server.
• Parameterized and cascaded reports are also used to make the reports interactive with the users.
• Used Tidal to create the jobs and Schedule them as per the business needs.
• Supported multiple projects at a time.

Environment: SQL Server 2008 R2, SQL Server 2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), XML, TIDAL, MS Visual Source Safe and Windows Server 2008

Confidential, Deerfield, IL

SQL BI Developer

Responsibilities:

• Responsible for documentation of system related activities.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Converted DTS application to SSIS as assigned.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• 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.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments.
• Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• 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 Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• 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: MS SQL Server2005/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential, CA

SQL BI Developer

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task.
• Developed error handling routines for packages using both script tasks as well as in the error handling environment.
• Developed reports by using SSRS, organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server databases.
• Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations.
• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Extensive Experience in Migrating Database from SQL Server and .
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: Microsoft SQL Server 2000/2005/2008 Enterprise Edition, MS Access, ETL Packages (SSIS), Visual Studio, Visual Source Safe, DTS, T-SQL, Oracle 10g.

Confidential

SQL 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.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spread sheet using DTS.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to backup the database.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Worked with development teams in the design of physical databases and in modification.
• Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: SQL Server 2005, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, Visual Source Safe 2003, Microsoft Visio 2000