SUMMARY:

• Having around 7 years of development experience in various domains with expertise in Microsoft SQL Server 2008/2005/2000 and Microsoft’s suite of products likeSSIS, SSAS, andSSRS2008/05.
• Experienced in Creating, Configuring and Performance - tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MSSql server 2012 and MSSQL Server2005 respectively.
• Analysed and used Constellar hub to ETL source data for data warehouse experienced in creating complexSSISand DTS packages for ETL purposes. Implemented complicated transformations to be used inSSISpackages.
• Experienced in Data Conversion, Normalization and Data Modelling, Multi-Dimensional Modelling and involved in creation of Fact Tables, Dimension Tables, and Star Schema.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MSSQL ServerReporting Services 2005/2008 (SSRS
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports usingSSRS2008/2005.
• Designed and Developed new SSAS Tabular Models.
• Activebatch scheduling tool experience for building jobs and scheduling.
• A validation procedure using Talend DQ that would verify that the final data set match certain conditions.
• Installation/publication on Talend Platform for Data Management server
• Knowledge with Informatica Power Center transformations like Joiner,Router,Update Strategy,connected and unconnected lookups, Expressions, Sorter,Filter,Union,Normalizer.
• Expertise in Developing and Extending MSSQL ServerAnalysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.
• Adept in defining d relationships and calculated members in SSAS and used MDX queries.
• Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL coding, Performance Tuning and Query Optimization.
• Highly proficient in the use of T-SQLfor developing complex Stored Procedures, Triggers, Tables, user Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing andSQLjoins.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication Models.
• Expert in using tools like MSSQLProfiler, Index Tuning Wizard, Windows Performance for monitoring and tuningSQL Serverperformance.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS:

SQL Server Tools: SSDT,SSMS,BIDS,Report Builder, DTS, Profiler, DTA, Upgrade Advisor

Monitoring & compliance Tools: LiteSpeed, Spotlight, SCOM, SQL secure

ETL & Reporting Tools: SSIS, SSRS, SSAS, Excel 2010, Power View, Tableau Desktop 8

Databases: MS-SQL Server 2012/2008 R 2/2008/2005/2000, Oracle 9i,10g,11g

Programming Languages: SQL,T-SQL,PL/SQL,C,C++,JAVA,C#,VB

Operating System: Windows 95/98,NT,Windows XP/2003/2000,Unix,MS-DOS

Web technologies: HTML, XML, VBScript, SharePoint 2010,C#,ASP.NET,VB.NET

Tools: ERwin, Visual Studio 2008/2005,Visio,Visual Source Safe, Sub Version

PROFESSIONAL EXPERIENCE:

Confidential - Malvern, PA

MSBI Developer

Responsibilities:

• Designedand developedSSIS(ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• CreatedSSISpackage to load data from Flat File to Data warehouse and Report-Data mart usingLookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Design and Develop new SSAS Tabular Models.
• Experienced on Tableau Admin activities, Multidimensional database and writing SQL queries.
• Preparing Dashboards using calculations, parameters in Tableau
• A validation procedure using Talend DQ that would verify that the final data set match certain conditions.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements
• Used variousSSIStasks such as Conditional Split, Multicast, Fuzzy Lookup etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Preparing Dashboards using calculations, parameters in Tableau
• Wrote Technical specification for the related work for each SSAS Tabular models.
• Developed and deployed data transfers packages usingSSIS, also maintained the jobs running on Servers.
• Expertise in usingTFSto open bugs, create tasks and user stories, initiate change requests.
• UsedTFSsource control to deploy application.
• CreatedSSISPackages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR toSQL server. Responsible for implementation of data viewers,SSISLogging, error configurations for error handling the packages.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, and Reporting tools. Designed, deployed, and maintained of variousSSRSReports inSql server 2012.
• Proficient in creating queries inTFSto validate results ofTFS reports.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report usingSSRS2008. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Stored procedures triggers plus replication. Projects include client server ms .Net projects using C# &Sql Server, data warehousing projects using OLAP with MS Analysis Services.
• Created C# Scripts for iteration of files and for Query Building using Script Task Component inSSIS
• Expertise in Developing and Extending MSSQL ServerAnalysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history usingSSRS2008. Responsible for the Performance tuning of theSQL Commands with the use of theSQLProfiler and Database Engine Tuning Wizard.
• Developed Report Models using report builder and distributed reports in multiple formats usingSQL ServerReporting Services (SSRS) in Business intelligence development studio (BIDS Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Designed and built the dimensions and cubes with star schema usingSQL ServerAnalysis Services (SSASVB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow ofSSISpackage.
• Responsible for creating database objects like table, Views, Store Procedure, riggers, Functions etc using T-SQLto provide structure to store data and to maintain database efficiently.

Environment: MSSql server 2012,SSIS,SSRS, T-SQL, Visual Studio 2005, C#, MS Office 2007,SQLProfiler,Team Foundation Server.

Confidential, San Bruno, CA

MSBI Developer

Responsibilities:

• Used theSSISto migrate databases such as Oracle andSQL Serverdatabase, flat files to centralized IT destination.
• Involved in Developing, Monitoring and DeployingSSISpackages and successfully created dynamic configuration packages inSSIS.
• DesignedSSISPackages to transfer data between servers, load data into database, archive data file from different DBMSs usingSQLEnterprise Manager/SSMS onSQL Server2000/2005 environment, and deploy the data. Used Event Handlers for Exception Handling inSSISpackages.
• Design the web application using Flex and CNET programming languages.
• UsedSSIS/ETL transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed Report Models using report builder and distributed reports in multiple formats usingSQL ServerReporting Services (SSRS) in Business intelligence development studio (BIDSGenerated reports on wealth information, account information, research reports using adhoc reporting to be used by the clients and advisors.
• Developed and deployed data transfers packages to the appropriate destinations using ETL.
• Identified and worked with multi-valued parameters for parameterized reports inSSRS.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Developed complex reports using BO XI Crystal reports.
• Performed T-SQLtuning and optimization of queries for reports that took longer execution time using MSSQLProfiler, Index Tuning Wizard andSQLQuery Analyzer in MSSql server 2012.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly.
• Scheduled, maintained, and supported the distribution and access to reports through Crystal Server.

Environment: MSSql server 2012,SSIS,SSRS, T-SQL, C#, Crystal Reports 10, Visual Studio 2005, MS Office 2007,SQLProfile

Confidential, Bloomington IL

SQL Server Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained deferential integrity and implemented complex business logic.
• Extracted and loaded data intoSQL ServerDatabase usingSSISfor exporting data from flat file source toSQL Serverdatabase.
• Scheduled & Maintained ETL packages in terms of data validation and consistency.
• Experience in creating complexSSISpackages using proper control and data flow elements with error handling.
• Using Script Task to Display Messages in C.
• Deployed theSSISPackages from development server to production server.
• Extensively used various objects inSSISFramework such as Dataflow Components, Control Flow Elements, Connections Managers and Event Handlers for creating robust packages.
• Created reports for users in different departments in different states using web-enabled reporting bySQL serverreporting services and Share Point.
• DeployedSSRSreports in to Share point servers earlier deployed to Report manger sites.
• Created covering indexes, filtered Indexes for better Performance to resolve Lookup Operations.
• Created String functions to pass parameter’s in to stored procedures.
• Creation of user Databases, managing security and created stored procedures.
• Participated in Database Design and Code Reviews to ensure optimum Performance.
• Created dashboardSSRSreports under report server projects and publishingSSRSreports to the reports server.Work on C#, WCF, MVC.
• Used Report manager to deploy reports, schedule reports, and created groups and users.

  Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQLin Development environment forSql server 2012.

• Defined and created indexes for query optimization and revising scripts for optimal performance.
• Used Sub version as source control to store all the code, packages and reports.

Environment: Sql server 2012,SSRS, SSAS, T-SQL, SSMS, BIDS, Visio, C#, VB Script, Excel 2003, SharePoint.

Confidential, Port,Washington, NY

SQL ServerDeveloper

Responsibilities:

• Based on business requirement, developed the ComplexSQLqueries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Translated user requirements into functional and technical requirements in coordination with the Sr. Business Analyst.
• Analyzed thebusiness requirement and functional specifications provided by the data specialist.
• Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company.
• Responsible for making sure reports are scheduled and delivered in a timely manner
• Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Worked onSSISfor transferring data from Heterogeneous Data format toSQL Server.
• Created various ad Hoc and parameterized reports usingSql server 2012 reporting Services with data fromSQL Serverand MS Access as data sources.
• Cleaned the data and created fact and dimension tables, performed calculations required for the reports usingSql server 2012 environment and accomplished data modelling.
• Designed and architected cubes for building reports usingSQL ServerBusiness Intelligence Development Studio to support business reporting and forecasting processes.
• Designed and built the dimensions and cubes with star schema usingSQL ServerAnalysis Services (SSAS).
• Designed and developed web user controls, master pages, validation controls, CSS files using CNET, VB.NET, Jquery, XML, HTML and ASP.NET 2.0/3.5.
• Developed and designed cubes with around 45 dimensions, about 25 Measures and 20 calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions andKPI.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.

Environment: Sql server 2012/2000,SSIS,SSRS, SSAS, MS-Access, WIN2000/XP.

Confidential

SQL ServerDeveloper

Responsibilities:

• Requirement gathering - Solution design.
• Involved in the migration fromSQL server7.0 to 2000.
• Actively involved in Normalization of database.
• Designed DDL and DML for MSSQL Server2000.
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimize query performance by creating indexes.
• Involved in writingSQLbatch scripts.
• Created reports for users in different departments in different states using web-enabled reporting bySQL serverreporting services and Share Point.
• Write T-SQLstatements for retrieval of data and Involved in performance tuning of T-SQL.
• Worked on Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Perform daily database backup & restoration and monitor the performance of Database server.
• Create joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and ConfiguredSQL Server2000 on development server for designing and testing.

Environment: MSSQL Server7.0/2000, T-SQL, DTS,SQL ServerEnterprise Manager,SQLProfiler.