PROFESSIONAL SUMMARY

• Over Seven 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 2008,2005 and SQL Server 2000 / 7.0.
• Highly experienced in all aspects of SDLC such as requirement analysis, design, development, testing, implementation, deployment maintenance of Projects.
• Hands on Experience with Analysis Services SSAS , Integration Services SSIS and Reporting Services SSRS .
• Expert in modeling, Extraction Transform Loading ETL using DTS and SSIS 2005 and 2008R2.
• Hands on experience 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 scheduled DTS/SSIS Packages.
• Expertise on using ETL - Data Extraction, Transformation, Loading tools with heterogeneous sources like Oracle, MS Access, DB2 and SQL Server using SSIS 2008/ 2005 and DTS 2000.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating
• DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008R2.
• Excellent report creation skills using SSRS 2005/2008 and Crystal Reports and deploying, publishing and developing dashboards.
• Expertise in creating Ad-hoc reports with Report models and explained end users how to use it in the Report Builder using SSRS 2005/2008. Worked with report builder tool 3.0/2.0/1.0
• Proficient in handling parameterized reports in SSRS 2008R2.
• Experience in integrating the SSRS reports into web applications using Report viewer control.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience with optimizing cube using partitions and aggregations.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Experience in Excel pivot services.
• Worked on SQL BI solution integration with Microsoft share point server.
• Exposure to source safe, version controlling etc
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Confidential

SR.SQL Developer SSIS, SSRS

ROLES AND RESPONSIBILITIES:

• Involved in database design to create star schema using Dimensional and Fact tables
• Involved in all phases of SDLC including Requirements Analysis, Design, Development and Customization of the reports.
• Develop and maintain a real time data warehouse environment and create real time feed to all subscriber application from Data warehouse.
• Develop and support SQL server database objects and code for BAU Support.
• Develop and support SSIS integration jobs required to manage integration between application databases and the corporate data warehouse
• Develop and support SSAS Cubes and related processing tasks.
• Develop and support SSRS reports on MOSS 2010.
• Provide and maintain documentation for all developed objects and processes.
• Use MS TFS 2010 to track all end to end changes and artifacts
• Follow strict change control process throughout development lifecycle
• Develop and run test scripts to ensure the quality of code and integrity
• Follow data designs and architecture as prescribed by SQL team lead and Chief Architect

Environment:

SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio SSAS, SSIS, SSRS ,Service Now ITSM Data tools 2012, XML,SYBASE,MS Visual Source Safe and Windows Server 2003/2008/2012.

Confidential

SR.SQL Developer SSIS, SSRS

ROLES AND RESPONSIBILITIES:

• Involved in all phases of SDLC including Requirements Analysis, Design, Development and Customization of the reports.
• Involved in database design to create star schema using Dimensional and Fact tables.
• Creation of tables, views, Indexes and establishing the relationships between the tables and design the star schema using SQL Server 2012.
• Created SSIS packages to implement complex business logic.
• Published SSIS packages and SSRS repots in testing and production server.
• Created Jobs to execute SSIS packages, on daily, weekly and monthly time periods.
• Involved in creating complex table, matrix, sub reports and chart reports using SSRS.
• Mentor offshore team for any technical aspects and test offshore deliverables on both SSIS packages and SSRS reports.
• Involved in requirements analysis and attended requirements review meetings.
• Managed offshore team
• Facilitated meetings involving Development, QA and Business Teams in resolving high priority issues.

Environment:

SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio SSAS, SSIS, SSRS ,Service Now ITSM Data tools 2012, XML, MS Visual Source Safe and Windows Server 2003/2008/2012.

Confidential

Environment:

Teradata, SQL Server 2008, SQL Server Business Intelligence Development Studio SSIS, SSRS , MS Visual Source Safe and Windows Server 2003/2008.

Confidential

SQL BI Developer SSIS/SSRS

LabCorp provides leading-edge medical laboratory tests and services through a national network of primary clinical laboratories and specialty testing laboratories. With scientific expertise in esoteric testing, genomics, and clinical and anatomic pathology, LabCorp processes tests on approximately 470,000 specimens each day, applying advances in medicine and science to laboratory testing. JBDM is a warehousing project used for Decision making solutions. This project helps the business users in analyzing the client requirements and make business decisions in order to provide more testing capabilities.

Responsibilities:

• Ineracted 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.
• Managed indexes and optimized queries using execution plan.
• Used temporary tables, table variables and common table expressions CTE for the better performance of the queries according to the requirement.
• Involved in performance tuning of queries and SSIS packages which increases the performance and runs faster.
• 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 ETL packages to get the data from XML raw files and used XSD files to convert the raw file to desired format.
• Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.
• Used C .Net and Vbt.Net in Script tasks in order to validate the files and to get the latest files.
• Used Script component using C .Net to perform row by row transformations in data flow tasks.
• Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Upgraded SSIS 2005 packages to 2008 packages.
• Involved in testing the performance of SSIS packages over different servers in collaboration with platform labs.
• Created data flow tasks for logging the audit data of the packages.
• Used Event Handlers to handle errors in the packages.
• Deployed the SSIS Packages from development server to production server.
• Used script task to produce HTML reports and mail using SSIS.
• 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.
• Supported multiple projects at a time.

Environment:

SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio SSAS, SSIS, SSRS , XML, MS Visual Source Safe and Windows Server 2003/2008.

Confidential

SQL BI Developer SSIS/SSRS/SSAS

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 developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in daily loads Full Incremental into Staging areas, troubleshooting process, issues and errors using SQL Server Integration Services 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.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Calculated measures and dimension members using multi-dimensional expression MDX .
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes SSAS .
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services SSRS .
• 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 designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• 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 SSAS, SSIS, SSRS , .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential

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.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Converted Data Transformation Services DTS application to SQL Server Integrated Services SSIS as assigned.
• Creating reports using SQL Reporting Services SSRS for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services SSIS .
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services SSAS and Reporting service SSRS
• 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.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. Table, chart and matrix report .
• Designed SSIS Packages to extract, transfer, load ETL existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Analyzing, designing, building , testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. 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 .
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• 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.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• 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 , SQL Server Analysis Services SSAS , MS Visual Studio.NET 2008, TFS Share Point , Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential

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, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Developed error handling routines for packages using both script tasks as well as in the error handling environment.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated measures, dimension members using MDX, mathematical formulas and user defined functions, named calculations using SSAS for generation of cubes.
• Implemented various notifications based upon the scheduling jobs, database monitoring, disaster recovery plans and wrote windows scripting scripts for automation of the tasks.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C .
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Responsible for creating parameterized, cascading, configuration, drill down, rollup reports using SSRS and deploying them into server using report builder.
• Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server, DB2 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 2005 to 2008 and 2005 to 2002.
• 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 , SQL Server Analysis Services SSAS , MDX, .Net, VB.Net, HTML, IIS, 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, IIS 6, Visual Source Safe 2003, Crystal Report 10, Crystal Enterprise 10, Microsoft Visio 2000