SUMMARY

• 8+ 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, Workflow 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 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
• Reporting services 2008/2005
• MS Office 2007/2003/XP/2000
• Oracle 8i/9i
• TalenD
• DB2
• C
• C++
• C#.Net
• VB
• TOAD
• T-SQL
• ODBC
• ADO
• RDO
• DTS
• MS Access-XP 2000/97
• ERWIN Platinum
• MS Visio 2003
• HTML
• XML
• ER-Designer

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

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.
• Maintain Web and Windows applications using C#, ASP.NET.
• 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, C#.Net, ASP.Net, PETL, XML, T-SQL, MS Visio, Windows 7

Confidential, Morristown, NJ

MS SQL Server Developer/ETL 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, multicast, 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, Union, NJ

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the highly efficient system.
• Involved to write complex T-SQL queries and Stored Procedures for generating reports.
• Responsible for creation of new database objects like stored procedures, tables, views, triggers, function according business logics. Inserted XML file parameter in to the database tables using services.
• 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.
• Loaded flat files into stage tables by using Bulk Copy Program BCP and SSIS packages. Scheduled database jobs for automation of DBA tasks.
• Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources and ETL related operations. Partitioned large tables million rows tables using range partition.
• Performed data extraction from OLTP to DW for decision making using SSIS.
• Defined report layouts and wrote queries for drill down reports and identified and included report parameters using SSRS.
• Developed complex reports and provided to business people for further analysis. Responsible for make changes in application according to business logic.
• Developing various simple to complex reports using different Reporting tools like SQL Server Reporting Services (SSRS).
• Identified various data sources and established connections between source and the target using SSIS based on the required reports.
• Configured and managed primary- standby nodes for High availability of database for users and company standards.
• Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Generated plan for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• Administered SQL Server security, SQL Server automatic email notification and SQL Server backup strategy and automation.
• Provided support to the application developers on the application databases.
• Worked on linked servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.

Tools: & Technologies: MS SQL Server 2008R2/2008, MS SQL Server 2008R2 Reporting Services, MS SQL Server 2008R2 Integration Services, Business Intelligence and Development System 2008R2,XML, T-SQL, MS Visio, Windows XP.

Confidential, South Brunswick, NJ

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 ERwin, 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 subreport 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, Hartford, CT

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 multidimensional 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, Jacksonville, FL

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.
• Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services(SSAS)
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Created Indexes to get the high level performance.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for loading data from ODS to Datamart.
• Designed SSIS packages for synchronizing the data between two different servers.
• 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.
• Created Ad-hoc reports and cascading reports for historical data using SSRS.
• Experience in the design, development and maintenance of different cubes using SSAS.
• Involved in the post deployment maintenance of canned reports and cubes.
• Experience in designing the reports in ProClarity for SSAS cubes.
• Involved in the implementation of Performance Point Server (PPS).
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through Autosys

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

Confidential

MS SQL Server and BI Developer

Responsibilities:

• Designed and implemented report forms with Stored Procedure using T-SQL, which contain number of Subreports to bring data to Master report.
• Wrote and Optimized Triggers, Stored Procedures and Queries in T-SQL.
• Created database objects like tables, views and indexes.
• Created and modified stored procedures, triggers and cursors.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• 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.
• Involved in deploying SSIS packages for various environments.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy lookup, for each loop, multicast, column conversion, fuzzy grouping, script components
• Skilled in running jobs in Enterprise Manager using job-scheduling tool.
• Implemented logical and physical database modeling using Erwin tool.
• Created star schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.
• Designed and developed MOLAP cubes with SSAS.
• Designed and implemented complex SSIS package and scheduled it for OLAP to satisfy BI requirements using SSAS.
• Successfully implemented SCD transformation in SSIS and performed security.
• Responsible for the design, development and maintenance of several cubes.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• Performed partitioning of cubes as well as secured cubes with perspective and roles.
• Archived and restored data warehouse database.
• Defined attribute relationships between attributes in multi level hierarchy.
• Provided technical guidance and support to end-users by developing documentations required.
• Performed SQL and release final verification procedure to production.
• Assisted users to work with OLAP cubes into SSRS for enterprise reports.
• Audited and enforced database security, code and procedural standards..
• Modified existing reports and successfully implemented.
• Added already created reports to Publish on web service.
• Designed, developed, and tested complex queries for Reports distribution.

Tools: & Technologies: MS SQL Server 2005/2000, MS SQL Server 2005 Reporting Service, MS SQL Server Integration Services 2005, BIDS, Erwin, T-SQL, Windows XP.