PROFESSIONAL SUMMARY:

• Over 7+ years of IT experience with a strong background in Data warehousing projects design, development and implementation with SQL Server 2012,2008R 2/2008/2005/2000 in a high transaction and multi - server production environment..
• Experience in all phases of project life cycle, starting from business requirement gathering and analysis, development, testing and deployment.
• Hands-on experience with Erwin and strong knowledge of Relational database modeling and Dimensional database modeling concepts, Fact tables, Dimensions and star/snowflake schema implementation.
• Proficient in using T-SQL, writing Stored Procedures, Triggers, Functions, XML and Cursors in SQL Server.
• Expert in MS SQL Server 2005/2008/R2 suite of products i.e. SSRS (Reporting Services), SSAS (Analysis Services) and SSIS (Integration Services).
• Extensive experience using various transformations in SSIS as an ETL tool while transferring the data from various sources into the destination files.
• Experience in creating complex SSIS packages for ETL purposes using various transformations in SSIS 2005/2008.
• Transformed data from various data sources to SQL Server using BCP, T-SQL and SSIS 2005/2008.
• Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports, creating on demand and scheduled reports in SSRS 2005/2008.
• Created the OLAP cubes using various dimensions, attributes and creating SQL Server Analysis Projects using SSAS 2005/2008.
• Extensive experience in defining calculated members, partitioning in SSAS and used MDX queries, creating OLAP structures from OLTP databases.
• Experience in Performance Tuning and Optimization of queries and stored procedures.
• Proficient in using SQL Profiler, Execution Plan and Performance Monitor to analyze database performance.
• Performing Backups and Recovery, Replication, Security management, Jobs and working with Linked Servers.
• Experience in executing SSIS packages programmatically form console application.
• Proficient in Migration of database, successfully migrated database from SQL Server v7.0 to SQL 2000 and SQL 2000 to SQL 2005.

SKILLS:

MS SQL Server 2000/2005/2008 r2,2012, MS SSRS, MS SQL SSAS, MS SSIS, Erwin Designer 2000, AS400, DB2 SQL syntax, MS-Access 2000, C, C++, VB 6.0,Developer 2000, Erwin 4.0/4.1/4.2,Oracle 9i/10g, T-SQL, PL/SQL, ASP.NET,, HTML, XML, XSL, Visual Studio 2008, T-SQL,PL-SQL, Crystal Reports, ODBC, MS Office, Windows NT/ 2000 Server/ XP.

PROFESSIONAL EXPERIENCE:

Confidential, Cherry Hill, NJ

MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Designed SSIS Packages in SQL Server 2008R2 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
• Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers. work closely with Data modular to complete the data model
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2008 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks. work closely with cogon's report developer
• Developed functional and technical specifications documents such as the Business Scope Document and High Level Design Document.
• Configured and scheduled packages to be deployed out to a production environment using SQL server Table file configurations in SSIS.
• Configured packages for development, QA and Production environments
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions
• Wrote C# code in Script Component to separate data from flat file and loaded into database.
• Configured SQL Mail agent for sending automated alerts/email

Environment: Microsoft SQL Server 2008R2 and 2012, SSMS, SSIS, Microsoft Visual studio 2008,AS-400,SQL view point, System i-navigator,Cognos10.1,Team foundation server-2008,C#

Confidential, San Antonio, TX

BI Developer/Managing Consultant

Responsibilities:

• Developed functional and technical specifications documents such as the Business Scope Document and High Level Design Document.
• Solid Experience in working as a Data Analyst to perform system and risk analysis.
• Created functional/technical specifications based on business requirements.
• Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance
• Used SSIS packages to roll our data to Live Tables and to Claim Processing Database.
• Configure the SSIS Package for run time Parameters and Configured files as well as developing the Documents for Logging/Error Handling for SSIS Packages
• Scheduled and Maintained Packages by implementing Execute SQL Server Agent Job Task, History Clean Up, Maintenance Cleanup Task, Shrink Database, Rebuild Index Tasks for Metadata and Data Quality.
• Configured and scheduled packages to be deployed out to a production environment using SQL server Table file configurations in SSIS.
• Implemented Type 2 Slowly Changing Dimension to maintain Dimension History.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQLTask, bulk insert task, Execute package task, Send mail task, Transfer database task, for loop & for-each loop containers.
• Configured packages for Testing and Production environments
• Validated extracts received from upstream systems and determined the validity of the data, and if not finding out the rootcause.
• Generated Dynamic reports from Cubes using Report Builder and SSRS.
• Developed Variance reports using Reporting Services (SSRS).
• Experience in working as a Data warehouse Tester using Quality Center.
• Coordinated with project managers to setup times and schedules for testing and meeting arrangements, as well as giving any insight as necessary
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.

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

Confidential, NJ

MS SQL BI Developer

Responsibilities:

• Planned, Defined and Designed database based on business requirement and provided documentation.
• Coordinated with DBA in creating and managing tables, indexes, triggers, database links and privileges.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, Portfolio Report, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2005.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2008.
• Created reports, which retrieve data using Stored Procedures that accepts parameters.
• 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
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: SQL Server 2008, BIDS, SSRS, SSIS, SSAS, Microsoft Visual studio 2008

Confidential, Port Washington, NY

BI developer/Report Developer

Responsibilities:

• Worked with Business Analysts and users to understand the requirement.
• Tested the data with complex queries, joins, stored procedures, views and sub queries.
• Generated reports using SQL Server Reporting Services 2008/R2 from OLTP and OLAP data sources.
• Created tabular, matrix, chart, drill-down reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created dynamic reports using calculated field with expressions and changing properties using expressions.
• Created standard report Subscriptions and Data Driven report Subscriptions. Created report snapshots and cache for better performance.
• Generated test data and tested database to meet the functionalities and deliverable in the project documentation and specifications.
• Created several views and UDF’s to be accessed by the new front end applications.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Created several views and UDF’s to be accessed by the new front end applications.
• Created standard and data driven Subscription, used report manager for securities.
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Deployed the generated reports in SharePoint and created interactive reports using PerformancePoint services from cube.

Environment: Microsoft SQL Server 2005 Enterprise Edition, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Windows server 2003 and IIS 5.0, Visual Source Safe.

Confidential, Chicago, IL

MS SQL Server/SSIS/SSAS Developer

Responsibilities:

• Defined and designed the data sourcing and data flows, data quality analysis
• Identified the data source and defined them to build the data source views.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server Agent to automate the SSIS 2008 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005/2008 and then created reports using this data using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
• Tested and managed the SSIS 2005 and SSIS 2008 packages and was responsible for its security.
• Created 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.
• Developed and designed cubes with dimensions, Measures and calculated members.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Cross-Tab, Drill-down and Sub-Report using SSRS 2008.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, Erwin, MS Excel, MS word, Visual Studio 2005.