SUMMARY

• Over 6+ years of extensive experience in database design, development and administration wif MS SQL Server versions 2008/2005/2000/7.0 using SSIS, SSAS, SSRS (BI Tools) in Financial, Retail, Healthcare, Insurance and Banking industries.
• Good Business and System analysis skills to understand the requirements and customize client applications.
• Proficient in Installing SQL Server 2008/2005/2000 and configuration of their tools.
• Excellent Transact - SQL/ T-SQL (DDL/DML) programming skills.
• Excellent backend skills in creating SQL objects like Tables, complex Stored Procedures, effective functions, Views, Indexes, appropriate Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and data consistency.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience wif Business Inelegance Studio 2005.(SSIS/SSAS/,SSRS)
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Developed Multi dimensional Objects (Cubes, Dimensions) usingSQLServerAnalysis Services (SSAS).
• Dimensional Data Modeling and Cube development in SQL Server Analysis Services.
• Good understanding of SQL Server Reporting Services (SSRS) wif Report authoring, Report management, Report delivery and Report security.
• Worked as a SQL Server DBA in data warehouse environment; responsible for developing, support and maintenance for the ETL processes.
• Expertise in Creating Databases based on Functional Requirements and System Design.
• Extensively worked wif QA, release team and developers to give the required environment.
• Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member wif excellent analytical, troubleshooting, and problem solving skills.

PROFESSIONAL EXPERIENCE

Confidential

BI Developer

Responsibilities:

• Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
• Work wif other teams and team members in Verizon to resolve issues related to data. Interact wif clients to understand requirements. Maintain proper documentation of the various process and code.
• Extracted date from various source systems like TeraData, Sql Server and flat files as per the requirements.
• Updated and remediate existing Business Intelligence scripts and Teradata applications to reflect changing business data requirements.
• Performed database health checks and tuned the databases using Teradata Manager.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specification including source to target mappings, data dictionaries and transformations.
• Used SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Designed SSRS Report Model Projects in BI studio and created, modified and managed various report models wif multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Worked on various complex requirements of developing monitoring dashboards wif multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.

Environment: MS SQL Server 2005/2008, SSRS, T-SQL, SSIS,Teradata,Application, Win 2003 Advanced Server, PowerBuilder 5, Erwin v7.2, ASP.Net, C#.

Confidential, FL

SSIS/BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Designed SSIS Packages to transfer data from various sources like Informix, Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server 2008.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP systems and scheduled Jobs to call the packages and Stored Procedures using SQL Server Agent.
• Authoring stored procedures to move data through the ETL subsystem into the Property subsystem.
• Implementing model changes required by business changes.
• Defect remediation of the ETL and Property subsystems.
• Developing SSIS packages for extracting the data from Staging Database, Perform the QC Rule Check and loading into the National Property Database.
• Performance tuning of complex SQL queries and Stored Procedures to increase the performance and Worked on Exception Handling.
• Developing SSIS packages for extracting the data from Staging Database, Perform the QC Rule Check and loading into the National Property Database.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing. Extracted, cleaned and validated.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis..
• Creation of extended properties for database columns.
• Authoring SSIS packages for Data Importing, Cleansing, parsing and validation.
• Creation of stored procedure and triggers for automating tasks.
• Creation of tuned SQL Queries for maximum efficiency and performance.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures dat accept parameters.

Environment: MS SQL Server /2008, SSRS, T-SQL, SSIS, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, ERwin v7.2, ASP.Net, C#.

Confidential, Boston, MA

SSIS/BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Worked in gathering data and documenting it for further .
• Involved in Installation and Configuration of MS SQL Server 2008.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing. Extracted, cleaned and validated.
• Wrote T-SQL queries, Store Procedures and used them to build packages and maintain the history of the data.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Involved in the design and development of web forms for the application using ASP.Net.
• Created reports to retrieve data using Stored Procedures dat accept parameters.
• Generated various reports using SSRS 2008.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format
• Fine tuned SQL Queries for maximum efficiency and performance.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Provided documentation for all kinds of reports, Stored Procedures and SSIS packages.

Environment: MS SQL Server 2005/2008, SSRS, T-SQL, SSIS, Visual,SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, ERwin v7.2, ASP.Net, C#.

Confidential, Yonkers NY

SQL Developer/SSIS

Responsibilities:

• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.
• Optimized existing stored procedures and various T-SQL queries.
• Wrote Dynamic Store Procedure to move data from Staging to Application.
• Wrote User Defined Function to calculate Single Target Ratio, Product Element ratio and Element Product ratio.
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler.
• Added more audits and alerts in SSIS Packages in case of package failure.
• Created package to transfer data between OLTP and OLAP database using container, task and transformation to load underlying data in to the tables from Text files.
• Managed index, statistics and optimize queries by using execution plan for tuning the database.
• Developed packages to handle data cleansing and scrubbing using Derived Column, Conditional Split, Script task etc to clean data.
• Used Aggregate, Conditional Split, Union All, Lookup, Derived Column, Data Conversion, Multicasting and Merge Join Data Flow transformations in SSIS
• Created SSIS package using for each loop, sequence container to load multiple files from same source folder on different FTP location and to perform group task
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling in the packages.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
• Scheduled jobs to call the packages and Stored Procedures as per business requirement
• Deployed, tested and scheduled SSIS packages using SQL Agent.

Environment: Microsoft SQL Server 2008/2005/2008 R2, SSIS, SSRS, Report.

Confidential, Harrisburg, PA

SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design wif a significant effort towards application using ERWIN.
• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• Worked wif development teams in the design of physical databases and in modification.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Experience in Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2008 R2 Reports Services (SSRS).
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Proficient in SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
• Designed SSIS Templates for developing SSIS Packages in such a way dat they can be dynamically deployed into Development, Testing and Production Environments.
• Generated and Deployed ETL SSIS packages both design and code to process data to target databases.
• Developed complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition SP3, SSMS, SSIS, SSRS, SSAS, BIDS,Microsoft Visual studio 2005, Windows server 2003.

Confidential

SQL Developer/Front End Developer

Responsibilities:

• Write complex stored procedures to process prospective customer information and balanced the processing load between front end and back end.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2000.
• Monitored query using query analyzer and tuned queries and procedures to boost database performance.
• Used SQL profiler to optimize remote procedures and queries by creating workload files and setting various filters and parameters like cash hit ratios.
• Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.
• Assisted in designing and creating user Interface.
• Involved in design, development and testing of Page Ranking.
• Implemented in writing client side validations using JavaScript and VBScript.
• Involved in designing, developing GUI forms.
• Involved in developing business Logic.
• Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Reports.
• Involved in Database design, Data modeling and writing Stored Procedures.
• Designed database and generated customized reports.

Environment: ASP.NET2.0, ADO.NET, Microsoft Visual Stuidio.NET 2005, IIS,V5.1, SQL, HTML,SQL Server 2000, SQL Profiler,.NET Framework 2.