SUMMARY:

• About 8 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server in Development, Test and Production Environments.
• Expertise in writing T - SQL Queries using joins, Sub queries and Cursors in MS SQL Server
• Strong hands-on experience with MS SQL Server with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services of and SQL Server Integration Services.
• Strong hands-on experience with SQL, PL/SQL,SQL Developer
• Created custom specific and efficient SQL server/Oracle Reports using SSRS/Oracle Reports.
• Expert in defining Query for generating drill down reports in SSRS
• Excellent understanding of T-SQL (DDL and DML), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server
• Hands on experience in reporting tools like SQL Server Reporting Services (SSRS), Crystal Reports. Good knowledge in Microsoft Great Plains.
• Worked on projects using Agile/SCRUM methodology.
• Hands on experience with SQL programming and Transact-SQL in creating tables, Stored Procedures, triggers, user-defined functions, views, indexes, user profiles, relational database models.
• Worked extensively on Optimization and Tuning for increasing Query and Database performance.
• Experience in data migration between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Working experience designing STAR, SNOW FLAKE Schemas, database modeling, logical and physical database design using Erwin.
• Experienced in Extraction, Transformation and Loading (ETL) process using MS-SSIS, DTS application tools.
• 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, development, testing, and implementation.
• Knowledge in Microsoft performance point integration server or Performance point server and scorecards for SharePoint.
• Highly analytical and solid programming skills besides competent in handling critical situations.
• Involved in documentation, providing to fresh recruits and also participated actively in review meetings.
• Actively participated in team building and led many operations for maintaining healthy work environment.
• Ability to work independently and in a team, capable of handling time-sensitive issues in distributed environments.

TECHNICAL SKILLS:

Data Management Tools: Microsoft SQL Server SQL Server Integration Services Oracle SQLDeveloper11g

Reporting tools: Cognos, SAP Business Objects

ETL Tools: Informatica

Databases: SQL Server, DB2, Oracle

Languages: SQL, COBOL, CICS, JCL

Operating Systems: Windows, Z/OS

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Gathered user requirements to develop business logics, analyzed data needs and designed database solutions.
• Load necessary tables to database from Excel, XML and flat file source by SSIS.
• Completed complex SQL queries for analyzing purposes and created multiple stored procedures,views and UDFs to implement the business needs.
• Created multiple pivot tables using SQL query and stored them into views for future reportingneeds.
• Designed and programed transactions, stored procedures and Error log table to record Errormessages for debugging purposes.
• Responsible for debugging and tuning during the test period, creating indexes and security design for database to improve performance.
• Designed and created reports based on business requirement with drill-down, drill through and parameter features with the new database using SSRS.
• Deployed report to database server and set subscriptions on a weekly basis.
• Created visualization report to support the decision making process using Tableau.

Environment: MS SQL Server 2012, SQL Server Integration Services 2012, SQL Server Report Services

Confidential

BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Involved in gathering requirements from the business users and created the Functional Specifications, Technical Specs, Design documents and Approach documents.
• Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel, Flat Files and Oracle databases..
• Designed and Developed Complex SSIS packages for auditing Interfaces using SQL Server Integration Services.
• Developed SSIS Packages using XML, ADO.NET, OLEDB, file system, and Look up tasks
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS
• Created SSIS packages for File transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Developed custom Reports, Ad-hoc reports by using SQL Server Reporting Services (SSRS)
• Developed Tabular, Drill Down, Parameterized, Cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements using SSRS.
• Created Parameterized Reports and Linked reports using SSRS.
• Deployed SSRS Reports in SharePoint Environment..
• Created OLAP Cubes and Dimensions using SSAS in data warehouse environment.
• Executed T-SQL Stored Procedures, Functions, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
• Scheduled Complex Stored Procedures using SQL Server Agent.
• Monitored and modified Performance using execution plans and Index tuning.

Optimized Database Performance and Performed Maintenance duties such as tuning, backup and restoration.

Environment: MS SQL Server 2012, SQL server integration services (SSIS) 2012, SQL server reporting services (SSRS) 2012, TSQL Visual Studio 2010/2008, SharePoint Server 2010, VB.net, VB Script, MS Office 2007.

Confidential

BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Analysed business requirements, built logical and physical data models that describe all the data and relationships between the data.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Used various SSIS tasks such as Conditional Split, Derived Column, Fuzzy lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Designed and developed Excel Pivot reports, created excel dashboards by easy of geographical comparisons like Area/Region/Sub-Regions wise.
• Extensive Security features applied (global/regional/sub-Regional) on all Excel/SSRS reports.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS)
• Generated some reports usingSSRS(SQL Server Reporting Services) from OLTP and OLAP data sources.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Environment: Environment: MS SQL Server 2008R2/2005, Oracle 9g, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, TSQL, MS Excel, ASP.NET, Visual Studio 2008, OLAP, Windows 2007/2003, VB.NET.

Confidential

BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db, and SQL 2005)
• Extracted and Transformed data into Staging Servers.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• Design and develop dynamic advanced T-SQL, PL/SQL, MDX queries, VB.NET Scripts, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Transferred data using (ETL) to Data ware house Environment using SSAS.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Created daily tasks including backup and restore by using MS SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSAS package
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Documented all work, so user can easily understand the flow of process.
• Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures

Environment: MS SQL Server 2008 R2, SQL server Reporting Services, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) .VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Erwin7.2, SQL Server Profiler, Database Engine Tuning Advisor.

Confidential

BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Analyzed requirements and designed normalized and de-normalized tables and relationships using SDLC methodology including Data Modeling with Erwin.
• Designed complex T-SQL queries, User Defined Functions; Stored Procedures and Triggers in SQL Server 2008 R2/2008/2005 followed by analysis and testing of those database objects before deployment to the production server
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints
• Designed Extraction Transformation and Loading (ETL) process to source from Oracle applications as well as legacy data sources. Developed ETL processes to source data from flat files using SSIS 2008. Designed ETL processes to load fact and dimension tables in data warehouse
• Designed indexes to tune the ETL process performance. Developed, modified, and optimized complex queries and stored procedures to data retrieval and modification. Developed ETL auditing system using SSIS Event Handler and Custom Scripts

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, T-SQL,Mainframes, DB2, CICS, Cognos Impromptu 7.0, Cognos 8.1, Infront CPL1 programming

Confidential

BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Analyzed existing database and assisted in designing extensions to the data warehouse systems by creating ETL packages to migrate data from multiple sources to the SQL Server.
• Learnt and assisted on creating Triggers and Indexes to increase the performance of the data warehouse.
• Created Views for complex queries and designed security for each existing role in the database.
• Worked closely with the Data Architecture team and provided technical design recommendations on the data mart structures.
• Debugged and tuned existing database and process, and created error logging table in database to catch possible errors with stored procedures and transaction.
• Implemented script task with C# to monitor the row count number.
• Backed up and restored database among different servers.
• DeployedSSISprojects to different servers.
• Developed parameterized reports in SSRS for business users and other stakeholders.
• Deployed reports and scheduled subscriptions by using SSRS and Report Server.
• Implemented Report Server Securities by creating different roles.
• Creation of different kinds of reports about Tables, Views, Synonyms etc from the Oracle Database.
• Improved the performance of long running jobs by updating the SQL statements and creating indexes.
• Configured Repository Manager, created folders and managed objects in repository manager for Informatica.
• Worked on Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet and Transformations.
• Worked withETLtool Informatica to create mappings and workflows and transformations.
• Used Filter, Router, Aggregator, Lookup, Expression, and Update the Mapping Strategy transformations whenever required in the mapping.

Environment: Oracle8i, Informatica 6.1(Source Designer, Warehouse Designer, Mapping and Mapplet Designer, Workflow designer, workflow Monitor) windows 2003, Oracle 8i, SQL/PL SQL.