PROFESSIONAL SUMMARY:

• 9 years of IT experience in analysis, design, implementation & administration of business intelligence solutions with Microsoft SQL server 2012/2008R 2/2008/2005/2000 in development, testing & production environment.
• Extensive experience in Requirement Analysis, Work flow analysis, Design, Development & Implementation, Testing & Deployment of complete software development life cycle (SDLC) in field of Desktop Applications, Microsoft web and client/server technologies.
• Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Extensive experiences in developing Stored Procedures, Functions, Views, Triggers, XML and Complex Queries on SQL Server 2012/2008R 2/2008/2005/2000 /7.0 , Oracle.
• Expert in T - SQL Programming, query optimization and performance tuning.
• Proficient in using SQL Profiler, creating Execution Plan, Performance Monitor and DBCC Commands.
• Expert database designer and fluent in all aspects of database development including, design, normalization and optimization.
• Highly proficient in design and development of SQL Server Integration Services (SSIS) packages, importing and exporting of data and using various control flow task and data flow transformation.
• Hands on experience in cleaning and scrubbing of data with Lookup and Fuzzy Lookup transformations.
• Expertise in creating various type of reports such as Complex drill down & drill through reports, parameterized reports, Matrix reports, Sub reports and Charts using SQL Reporting Services (SSRS).
• Highly proficient in handling parameterized, drill down, drill through and chart reports using SSRS.
• Expert in dimensional data modeling, and cube development, partition, aggregation and optimization using SSAS.
• Highly Proficient in designing MDX in accessing cubes and hands-on experience in query structuring, performance optimization.
• Excellent command in deploying analysis projects using SQL Server Analysis services.
• Experienced in design and scheduling integration packages using SSIS.
• Successfully performed SCD transformation and deployed SSIS package with security.
• Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational database modeling and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.
• DTS applications moving data between different types of databases and legacy systems.
• Exceptional versatility and adaptability, extremely diligent, strong team player with an ability to take new roles. Excellent communication and strong analytical skills.

TECHNICAL SKILLS

MS SQL Server 2012/2008R 2/2008/2005/2000 , MS SQL Server Analysis and Reporting services 2008/2005, MS Office 2007/2003/XP/2000, Oracle 8i/9i, Talen, DB2, C, C++,C#,VB, TOAD, T-SQL, ODBC, ADO, RDO, DTS, MS Access-XP2000/97, ERWIN Platinum, MS Visio 2003, HTML, XML, ER-Designer

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

MS SQL Server Developer/ETL Developer

Responsibilities:

• Work with business analyst to identify and understand source data systems.
• Map source system data to the data warehouse, data marts.
• Created complex SSIS packages to extract data and scheduled Jobs to call the packages using SQL server agent.
• Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Cache Transform and Derived column while developing the packages.
• Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Involved in package configuration to make the packages dynamic for successful execution of packages in development and production environment.
• Scheduled database jobs for automation of DBA tasks using SQL Server Agent.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Worked on SSIS to import the data from different format.
• Developed SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Worked on Team Foundation Server for Version Control.
• Created various Tabular and Matrix Reports using SSRS.
• Proficiently created Reports based on the requirements using SSRS 2008.
• Configured the report viewing security for various users at various levels using Report Manager.
• Successfully worked with Report Server and configured into SQL Server 2008.
• Created Batch files to run the script in development, production environment.

Tools & Technologies: MS SQL Server 2012, MS SQL Server Integration services 2012 (SSIS), MS SQL Server Reporting Services, MS SQL Server 2008R2,MS SQL Server 2005, PETL, XML, T-SQL, MS Visio, Windows 7

Confidential, Jersey City, NJ

MS SQL Developer/SSRS Developer/SSIS Developer

Responsibilities:

• Worked on SSIS to import the data from Excel sheets.
• Developed SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, for each loop, multi cast, data conversion, Derived column, fuzzy grouping, script components
• Loaded Excel files into stage tables by using Bulk Copy Program BCP and SSIS packages.
• Successfully deployed SSIS packages with defined security.
• Involved in package configuration to make the packages dynamic for successful execution of packages in development and production environment.
• Scheduled database jobs for automation of DBA tasks using SQL Server Agent.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Implemented data views and control tools for guarantee data transformation using SSIS.
• Responsible to monitor performance and optimize SQL queries for maximum efficiency.
• Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
• Tuned SQL queries using execution plans for better performance.
• Created stored procedures for the business logic using T-SQL.
• Performed coding of several database triggers and stored procedures and maintained integrity constraints.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient manner.
• Involved in performance tuning of SSIS Packages.

Tools & Technologies : MS SQL Server 2012, MS SQL Server Integration services 2012 (SSIS), XML, T-SQL, MS Visio, Windows 7

Confidential, Detroit, MI

SQL Developer/ETL Developer

Responsibilities:

• Carried out a Developer’s role on MS SQL Server 2008 (using SSIS, T-SQL, Stored Procedures and Views).
• Used ER-win, Normalization, Dimension Modeling and Enterprise Manager for Logical and physical database development.
• Imposed Referential Integrity of data by creating different constraints.
• Migration of the data from text files to SQL Server database and SSIS packages for the processing of different policies.
• Managed all indexing, debugging, optimization and performance tuning
• Created stored procedures, triggers and functions for the business logic using MS SQL.
• Performed coding of several database triggers and stored procedures and maintained integrity constraints.
• Designed and developed Data Transformation Process.
• Successfully performed SSIS packages and scheduled them.
• Used advanced features of MS SQL in order to design and tune MS SQL to interface with the database and other applications in the most efficient manner.
• Effectively used views to prevent unauthorized access in database.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production
• Created numbers of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report.
• Developed various Charts and Graphs like bar charts, line charts, pie charts etc. by using chart experts for BI needs.
• Built and performed user acceptance testing on new and modified reports.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Used Query for ad hoc Reports and Users design Custom Queries.
• Analyzed reports and fixed bugs in stored procedures

Tools & Technologies: MS SQL Server 2008, SSIS 2008, T-SQL

Confidential, Seattle, WA

MS SQL Server Developer/SSAS/SSIS

Responsibilities:

• Designed a complex SSIS package for importing data from SQL Server 2005.
• Implemented data views and control tools for guarantee data transformation using SSIS.
• Extensively worked on SCD transformation in SSIS package.
• Successfully deployed SSIS packages with defined security.
• Developed logical database and converted into physical database using Erwin.
• Proficiently created Reports based on the requirements using SSRS 2008.
• Involved to write complex T-SQL queries and Stored Procedures for generating reports.
• Defined parameters for parameterized Reports using SSRS.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2008.
• Successfully worked with Report Server and configured into SQL Server 2008.
• Created Batch files to run the script in development, production environment.
• Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data.
• Extensively worked with OLAP cubes to generate drill through reports in SSRS.
• Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization.
• Responsible to monitor performance and optimize SQL queries for maximum efficiency.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
• Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system.
• Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
• Tuned SQL queries using execution plans for better performance.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance.

Tools & Technologies: MS SQL Server 2008/2005, SSAS 2008, SSIS 2008, T-SQL, ORACLE

Confidential, Falls Church, VA

MS SQL Server Developer

Responsibilities:

• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Maintained databases, performed software installations and monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Created Indexes to get the high level performance.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Involved in reverse and forward loading of the schema of a database using Erwin.
• Responsible for gathering Business Requirements and System Specification from users.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Involved in the post deployment maintenance of canned reports and cubes.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through AutoSys

Tools & Technologies: MS SQL Server 2005, SSIS 2005, T-SQL, Windows 7, Office 2005.