SUMMARY

• Around 7+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, UNIX & OLAP.
• Extensively worked on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
• Excellent knowledge of entire Software Development Life Cycle(SDLC) methodologies like waterfall model and Agile methodology
• Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.
• Experience inOLTP/OLAP environment and Data Warehouse.
• Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Work experience on MS SQL Server 2014/2012/2008 R2/2005/2000, Oracle, VB 6, crystal reports
• Experience indesigning, developing and deploying Business Intelligence solutions using SSIS,SSRS
• Designed and developedmatrix and tabular reportswithdrill down, drill throughusing SSRS.
• Experience inwritingComplexSQLQueriesinvolving multiple tablesinnerandouter joins.
• Worked as MS SQL Server Developer on enterprise and performance critical applications.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server.
• Involved in migration of legacy data by creating various SSIS packages
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill - down, Drill-through And Cascading reports using SSRS.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Expert in generating drill down reports in SSRS 2008.
• Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and csv and XML files using SSIS.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool.
• Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.
• Developed interactive web-based reports and forms with VB.NET and ASP.NET and ADO.NET and html.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Exceptional Computer Science background with programming skills in VB as a Junior Programmer.
• Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.
• Experience in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
• Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
• Proficient with automated testing tools - Win Runner, Load Runner and QTP for testing Client / Server and Web based applications
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
• Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Ability to work excellently as an individual and also as part of a team with minimum amount of supervision.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2014/2012, 2008R2, 2005, 2000, Oracle 11g/10g

Database Tools: SQL Server Entreprise Manager, SQL Server Intégration Services (SSIS), SSAS, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), DTSX, Data Stage PX 8.5/8.1,7.5.3, Team Foundation Server (TFS)Reporting Tools Microsoft SQL Server Reporting Services (SSRS), Crystal Reports

Operating Systems: Windows 7, Windows XP, 2000, Windows 2003 server, Windows 98

Programming Languages: SQL,T-SQL,PL/SQL,XML,HTML,VisualBasic6,VBScript, C#,.NET,VB.NET,ASP.NET,ADO.NETDesign Tools Erwin 7/4, MS Visio 2007/2010

BI Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• 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.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Used Office SharePoint Server 2007, information workers can assemble data from multiple sources and publish that data on the Web.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Used SharePoint Report Center is a site that provides a central location for storing reports that are common to a group.
• 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 designingParameterized Reportsfor generatingAd-Hocreports as per the client requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• 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.

Environment: SQL Server 2014/2012, SQL BI Suite (SSIS, SSRS, SSAS), T-SQL, C#. Net, XML, SQL* Profiler, TFS, DTS, OLAP, Windows 2008/XP, MS Visio 2010, Office SharePoint Server 2007 Crystal Reports

Confidential, PA

SQL Server/BI Developer

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed software and database solutions.
• Worked closely with database to design and implement database components in timely manner..
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Created SQL server Analysis Projects andcreated multi-dimensional databases and OLAP cubesand dimensions for the analysis of capacity planning task in specific areas for departmental manager using SSAS.
• Identified and defined Fact relationships in SSAS, Created cubes, dimensions, KPI, Measures and calculations.
• Involved in writingMDXqueries and manipulating the multidimensional data inOLAP cubes.
• Involved in identifying and creating data sources and data source views in SSAS. Involved in Creating Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing production support for the application as required.
• Created partition using partition scheme and functions of SQL server to achieve better performance in retrieval of data from database.
• Schedule Jobs to run SSIS package.
• Load data from database to Data warehouse using SSIS packages.
• Involved in designing Parameterized Reports and also cascadedParameterized Reports.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2012 Server to achieve the efficiency of SQL Server Analysis(SSAS)
• Created security roles and perspectives in the cube using SSAS.
• Created SSIS packages to load the daily transactional data into the database.
• Created reports from complex SQL queries and MDX queries in Agile (Scrum) methodology
• Organized data from a data warehouse into multidimensional cubes with SQL Server Analysis Services (SSAS) to allow the execution of sophisticated reports and complex queries.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Created MDX queries to extract data from the Data Mart.
• Created calculations of queries with MDX in SSAS, developing reports using MDX and T-SQL.
• Worked on troubleshooting, performance tuning, performance monitoring and enhancement of Data stage jobs.
• Developed complex Stored Procedures and Functions and incorporated them in Crystal Reports to enable report generation on the fly (SSRS).
• Create and execute unit, functional and integrated testing.
• Responsible for maintaining UAT (User Acceptance Testing) and Production Environment
• Provided 24/7productionsupport for the production database and also to the code deployed into the production environment

Environment: SQL Server 2012, SQL BI Suite (SSIS, SSRS, SSAS), Enterprise manager, XML, MS PowerPoint, MS Project, MS Access 2007, MS office 2013 pro plus, TFS, Agile, Crystal Reports.

Confidential, Bloomington, IL

SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

• Actively participated and interacted with project manager and other team members to process the complex business logic and requirements of the project.
• Built different types of chart reports for the business requirement like column chart, Pie Charts using MS SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions, and Functions and formatted the report layout for the requirement of the end users.
• Created and modified data driven subscriptions using SSRS Report Manager.
• Created stored procedures, triggers, views, user defined functions to in corporate the flow of business and called various stored procedures from SSIS to make the flow of SSIS effective.
• Worked on Common Table Expressions (CTEs) which makes a reusable expression part of a query.
• Worked on Report Builder to create ad-hoc reports based on information stored in both relational and OLAP data stores using SSRS.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Responsible for extracting data using SSIS from OLTP to OLAP.
• Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Identified and optimized long running queries, poor indexing, parallelism issues, etc. and their effects on the database application.

Environment: MS SQL Server 2005, SSIS 2005, SSAS 2005, SSRS 2005, OLAP, Business Intelligence Development studio, SQL Profiler, Index Tuning Wizard, Oracle 9i, Windows 2003 Server, Visual Studio 05

Confidential, Houston, TX

SQL Server/BI Developer (SSIS)

Responsibilities:

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to DW
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Developed and deployed data transfer packages using SSIS, also maintained the jobs running on Servers.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Generated reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple TSQL.
• Used to develop the reports by using SSRS and Power Pivot.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the SSRS report.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics, Tableau Reports using SSRS
• Designed and developed Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Proficiency in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining, Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Configured the report viewing security for various users at various levels using SSRS Report Manager.

Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services 2008/2012MS SQL Server Reporting Services 2008 (SSRS), Visual Studio 2008, Win NT /2000/ 2003, MS Office 2003/2007, PL/SQL, Microsoft Office Share Point - 2008, C#, VB.Net.

Confidential, Minneapolis, MN

SQL Server/SSIS Developer

Responsibilities:

• Created and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Written different T-SQL scripts for automated execution of the tasks.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Extensively used SSIS to move data from heterogeneous data sources to SQL Server.
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files.
• Scheduled and executed different automated and manual jobs once the package is executed.
• Managed the Clustered environment databases and was fixing the errors when they arose.
• Rebuilding the indexes at regular intervals for better performance.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Written complex stored procedures and functions and integrated it with the front end application.
• Created multi-dimensional cubes with different dimensions and measures in it using SSAS.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
• Prepaid user manual and technical support manual.

Environment: Windows server 2003, MS SQL Server- 2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLTP, Tortoise SVN, MS Office-2007, MS Excel.

Confidential

SQL Server BI Developer

Responsibilities:

• Worked as Test Engineer
• Developing test plan and test strategy
• Review of the test cases written for unit and integration level
• Integrating the test scripts written for individual units
• Writing Test scripts and functions wherever necessary for various units of the business modules
• Effective coordination between development team and testing team
• Writing RTMs before the test planning phaseAnalysis of the specifications provided by the users
• Generating reports using crystal reports
• Coding in VB6.0
• Writing SQL Server database procedures, functions and triggers
• Responsible for overseeing the Quality procedures related to the project

Environment: Visual Basic 6.0, Windows 2000 operating system, Microsoft SQL Server 2000 server, Microsoft Excel, Microsoft Word, Visual Source Safe