SUMMARY

• Over 10 years of IT Experience in Database Design, Implementation, Development and support in Information Technology field and solved many complex business problems.
• Proficient in gathering Business Requirements from business stakeholders, Analyzing documenting System Requirement specification, Functional Requirement specifications and maintaining Requirements.
• Excellent knowledge of Software Development Life Cycle (SDLC), Data Warehouse Life Cycle (DWLC)
• Hands on Experience on Data warehouse concepts Normalization and Demoralization.
• Strong experience in MS SQL Server with Business Intelligence in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS.
• Expert in writing T - SQL, working on DTS, SSIS, SSRS Data Cleansing, Data Scrubbing and Data Migration.
• Proficient in handling parameterized reports in SQL 2012 Reporting Services.
• Expert in defining Query for generating drill down reports in SQL 2012 Reporting Services and designing stylish report layout.
• Experienced in using global variables, expressions and functions for the reports.
• Experience in developing Custom Report 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 with SSAS Tabular Model. Experience in creating SSAS cube by using dimensions and measures.
• Experienced in sorting the data, defining data source and subtotals for the reports.
• Experience in creating Jobs and scheduled DTS Packages.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SQL 2012 Reporting Services.
• Highly Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions.
• Experienced in creating Tables, Views, Indexes and other SQL joins and query writing.
• Experienced in writing SQL Query with Temporary Tables, Creating an inline table-valued function, Table Variables And Common Table expressions (CTE).
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
• Strong analytical and problem-solving skills coupled with excellent documentation, verbal and inter-personnel communication skills and ability to acquaint to fast changing skills.
• Effectively manages time spent on multiple projects to meet deadlines.
• Experienced in Teradata utilities like BTEQ, Fast Load, Multi Load, Tpump, Fast Export and Teradata SQL.
• Good Knowledge in TERADATA data warehouse architecture.
• Team player and self-starter with excellent communication skills, ability to work independently or as a part of team and capable of picking up new skills quickly.

TECHNICAL SKILLS

Operating Systems: Windows 2000/ NT/ XP/ Vista/98/ 95, Windows 2003 server.

SQL Server Tools: Enterprise Manager, Profiler, Query Analyser, Export & Import

RDBMS: MS SQL Server 2000/2005, Teradata 12, MS Access

Databases: SQL Server 2012 & SQL Server 2008/2005/2000.

ETL: DTS, SQL Server Data Tools,SSIS

Reporting: SQL 2012 Reporting Services, Cognos Report Studio 8.4, Cognos Framework Manager, Query Studio, Crystal Reports.

Programming Languages: SQL, PL/SQL, T-SQL, VB.Net

Teradata ETL Tools: FastLoad, BTEQ, MultiLoad, Fast Export, Tpump

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

PROFESSIONAL EXPERIENCE

Confidential

SQL Server ETL & BI Developer

Responsibilities:

• Involved primarily in the Requirements Analysis, developed BI reports from OLAP Cubes with SSRS Reporting.
• Developed different kinds of reports using the SSRS reporting as per the user’s requirements and deployed in report server.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• 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 named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions. Used MDX to create calculated members in the cube.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Extensively worked on T-Sql when doing incremental and Full loads
• Involved in Designing and updating Table properties
• Creating and scheduled Jobs which when scheduled would load into Sql server on daily and Hourly bases
• Deployed the generated reports directly on the client’s workstation.
• Looked at the reports and fixed bugs in stored procedures.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Experienced in writing SQL Query with Temporary Tables, Table Variables and Common Table expressions (CTE).
• Experienced Creating an SQL Server inline table-valued function and Multi statement Table Valued Function.
• Created Table, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Experience with SSAS Tabular Model. Experience in creating SSAS cube by using dimensions and measures.
• Involved in unit Testing

Environment: Visual Studio 2012, SQL Server Data Tools, SQL 2012 Reporting Services, SQL Server 2005/2008 Enterprise, MS VISIO, SSRS, SSIS, VB .NET, Crystal Reports.

Confidential

SQL Server ETL & BI Developer

Responsibilities:

• Developed ETL Packages using SSIS (Integration Services) for Complex Data Transformations.
• Designed and Developed SSIS packages in order to migrate and transform the data across various servers (Databases) based on business rules.
• Report Development in SSRS (Reporting services) and delegate work to track the progress.
• Preparation of the Functional Specification Document and Design Document Responsible for the overall project across all the applications.
• Developed system integration and test plans and conducted integration testing for user acceptance.
• Onsite-Offshore Coordination.
• Discussions with the client to understand the correct scope of this project and clarifications.
• As a SSIS developer extensively worked in Extracting data from various types sources like Flat Files, Excel and Transformed them to OLTP
• Created store procedures for computation in Fact Table
• As a Micro soft SSIS developer used its powerful concept of Merge statement and transformed data from staging Environment to OLAP
• Designed 80 packages, from which 70 are dimensional and 10 are Fact Tables
• Used various tasks like scripts task, Dataflow, Control Flow in creating various packages according to the requirements
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server, Oracle and XML using SSIS, BCP and Bulk Insert.
• Developed, monitored and deployed SSIS packages. Monitored Scheduled jobs and alerts. Used different XML configurations depending upon package environments
• As a SSRS developer generated various reports like Tablix, Matrix, Graphs Reports
• Created stored procedure for generating reports using SSRS.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Created client side reports (RDLC) using Visual Studio 2008 for reports to be generated from session data
• Built reports to generate in desired form (Word, PDF, Excel and XML) to present statistical information according to business requirement. Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL.
• Improved Report Performance and performed unit testing at time of integration.
• Created SQL objects like Tables, Stored Procedures, Views which helped in created SSIS packages and in building reports

Environment: SQL Server 2005/2008 Enterprise, SSIS, SSRS 2008 R2, MS VISIO, VB .NET.

Confidential

COGNOS Business Intelligence Developer

Responsibilities:

• Generated different kinds of reports using the Cognos Report Studio 8.4 as per the user’s requirements and Dimensional modeling in Cognos Frame work Manager.
• Created prompts for user defined conditions, pre defined conditions which allow the users to pre select a condition value when they are running the queries.
• Provides wide variety of user friendly ad-hoc reporting capability for business users.
• Provides a web based front-end for viewing reports.
• Responsible for unit testing and fixing the issues.
• Maintaining quality control measures.
• Responsible for delivering the projects.

Environment: Cognos Report Studio 8.4, Cognos Framework Manager, Query Studio, SQL Server 2005.

Confidential

SQL Server MS BI Developer

Responsibilities:

• Work with the direct client and oversee the system development process including systems analysis, technical design, coding, testing, and turnover to production of the application.
• Analyzing the Requirement Specifications for all the applications and shared the same with team.
• Preparation of the Functional Specification Document and Design Document.
• Discussions with the client to understand the correct scope of this project and clarifications.
• Responsible for the IA Reporting System and OLAP Module across all the applications.
• Coordinate and delegate work to track the progress.
• Provide technical leadership to technical resources and customers to meet project deadlines and ensure project objective are met.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Migrated Organization, Orders, Adjustments, Objectives data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service Worked with handling the xml data and worked with querying the xml, and export/import xml data integration with SQL server.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Looked at the reports and fixed bugs in stored procedures.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Environment: SQL Server 2005, SSIS, SSRS (Reporting services), SSAS (Analysis services)

Confidential

ETL (Informatica &Teradata) Developer

Responsibilities:

• Analyzing the Requirement Specifications and discussions with the client to understand the correct scope of this project and clarifications.
• Designing the Logical Data Model and Physical Data Model for the new modules.
• Analysis of SAS scripts for the logic and implementing the same using BTEQ scripts.
• Designing the temporary/ volatile tables needed to implement the logic
• Discussions with the client to understand the correct scope of this project and clarifications.
• Preparation of the Functional Specification Document and Design Document.
• Unit testing of the data after the scripts are run and sending the test log to onsite.
• Coordinating with the onsite for resolution of issues.
• Knowledge transition to the new members into the team.
• Identifying areas for process / performance improvements and/or enhancements.
• Develop and maintain technical documentation on Confidential Knowledge Repository; compile documentation for design changes or creation criteria.

Environment: Informatica Power center 8.1.1, Teradata V2R5, Teradata Utilities.

Confidential

SQL Server MS BI Developer

Responsibilities:

• Developed ETL Packages using SSIS (Integration Services) for Complex Data Transformations.
• Designed and Developed SSIS packages in order to migrate and transform the data across various servers (Databases) based on business rules.
• Preparation of the Functional Specification Document and Design Document Responsible for the overall project across all the applications.
• Developed system integration and test plans and conducted integration testing for user acceptance.
• Onsite-Offshore Coordination.

Environment: SQL Server 2005, SSIS, SSRS (Reporting services), SSAS (Analysis services)

Confidential

SQL Server MS BI Developer

Responsibilities:

• Developed ETL Packages using SSIS (Integration Services) for Data Transformations.
• Developed system integration and test plans and conducted integration testing for user acceptance.
• Discussions with the client to understand the correct scope of this project and clarifications.
• Preparation of the Functional Specification Document and Design Document Responsible for the overall project across all the applications.
• Coordinate and delegate work to track the progress.
• Work with the Onsite lead, offshore lead and Program manager to manage and oversee the system development process including systems analysis, technical design, coding, testing, and turnover to production of the application.

Environment: SQL Server 2005, SSIS, SSRS (Reporting services), SSAS (Analysis services)

Confidential

SQL Server MS BI Developer

Responsibilities:

• Designed and Developed SSIS packages in order to transform the data across servers (Databases).
• Experience in writing Complex stored procedures and functions.
• ETL development (server jobs and parallel jobs) with expertise in SSIS packages
• Installation of the SSIS packages in various environment.
• Developed system integration and test plans and conducted integration testing for user acceptance.

Environment: SSIS (Integration Services), Crystal Reports.

Confidential

SQL MS BI Server Developer

Responsibilities:

• Involved in developing the windows application and core integration process.
• Preparation of unit testing scripts and fixing bugs. Created Database Diagrams. Defined relationship between tables and enforced the referential integrity constraints.
• Design and implement Stored Procedures, Complex Queries using Joins & Sub Queries for inserting the customer data, to get the customer details and get the Category Plans.
• Wrote (T- SQL) and fine-tuned complex stored procedures using control of statements (Case, if else and While).
• Designed Views that are frequently required for the application.
• Created the database objects like tables and related table constraints.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Wrote T-SQL statements for retrieval of data.

Environment: Microsoft SQL Server 2000, C#.net, ADO.Net, Crystal Reports