SUMMARY

• An IT professional with more than 7 years’ of experience in end - to-end implementation of Business Intelligence and Data warehousing projects as a Business Analyst, Developer and Quality Analyst using SQL server Management studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Experience with Microsoft BI stack: SQL Server 2008 R2, SSIS, and SSRS. Proficient in developing, troubleshooting, and supporting SQL Server 2008 R2 database objects, T-SQL, SSIS, SSRS, and MS Access.
• Experience in creating Databases, Tables, Stored Procedures and functions, Triggers, Views, Cursors and Indexes on SQL server.
• Worked on writing complex SQL queries, performance tuning and Query Optimization on SQL server.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Created complex SSIS packages using multiple data sources, and worked on creating jobs, Alerts and scheduled them using SQL Server Agent and JAMS.
• Excellent understanding of SSIS architecture, configuration tools and XML processing.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Good expertise in designing reports using SSRS and Excel Power Pivot table based on OLAP cubes.
• Worked on creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports using SSRS. Develop and maintain MS SQL Server Analysis Services (SSAS) 2012 Cube/OLAP warehouse.
• Formulated efficient MDX queries for applications and reports without use of a query builder application. Participated in ad-hoc projects and assignments as required.
• Hands on experience in scheduling and deploying reports on report manager.
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SSAS.
• Worked on Developing and Extending OLAP Cubes, Dimensions and data source view also on writing MDX Scripts for the OLAP CUBES.
• Good understanding of Data Warehousing concepts and ability to create star schema and snow flake schemas according to the requirement.
• Good knowledge on installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server
• Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.
• Extensive experience in interacting with business users to identify information needs, gather Requirements, and authoring Business Requirement Documents.
• Extensive experience with different phases of software development life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• Advanced knowledge and understanding of MS Excel, pivot tables (2010) and different types of data connections (OLAP/ODBC) required. Proven experience working with MS SQL: Server Analysis Services (SSAS) - Dimension, Measures and Key Performance Indicators (KPIs). Proven OLAP database experience writing Multidimensional Expressions MDX queries and Drill-Down/Thru approaches.
• Advanced knowledge and understanding of MS Excel, pivot tables (2010) and different types of data connections (OLAP/ODBC) required.
• Good experience in Creating, deploying SSIS Packages and migrating DTS Packages from /2008.
• Migration of SSRS reports from SQL 2005 to SQL 2008

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL. C, C++, VB 6.0,Perl,CSS, HTML, XML

Databases: SQL Server 2012/2008/2005/ , Oracle 9i/8.x, 10g, 11g, DB2 MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Other Software: MS Office- 2007/2003/2000 , Adobe Professional, SharePoint

Operating Systems: Windows / 98/2000/2003/ XP/Vista/8

Database Tools: ERWIN, SQL Query Analyzer, SWIFT Tool, SQL Enterprise Manager, SQL Server Management Studio(SSMS), SSDT 2012, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, TX

Senior BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables
• Created User Defined Functions, Stored Procedures, and Triggers.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle,DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
• Created data loads and Performed Data validations
• Created packages in SSIS with error handling. Worked with different methods of logging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Have deployed packages on different servers by configuring it.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Configured variables for connection parameters and SSIS components/Tasks in the packages in case of deployment from one environment to the other
• Worked on building and deploying the packages from Development to Test to production environments using XML configurations and environment variables, developed staging tables and configured SSIS packages on loading these tables
• Monitoring the jobs in case of heavy data loads and high memory usage.
• Involved in planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Created Reports from Web Services and used MDX on Cubes in SSAS to create reports in SSRS.
• Designed, created, and managed multidimensional structures that containing aggregated data from several sources, such as relational databases, spreadsheets, text files etc.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Used SSAS for creating and visualizing data mining models that are constructed from other data sources by using a wide variety of industry-standard data mining algorithms.
• Worked on SSRS to generate reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used MS Team Foundation server for Code Check -in and check out.
• Prepared documentation related to database design, Low-Level-Design Documents, Service Level Agreement and Unit testing plan and scripts.

Environment: SQL Server 2012/2008R2/2005, Query Analyzer, Enterprise Manager, TFS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.

Confidential, Jacksonville

BI Developer

Responsibilities:

• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Created data loads and Upgrade scripts for data migrations and validations
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Have deployed packages on different servers by configuring it.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.
• Created, worked and managed OLAP Cubes in SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Worked on SSRS to generate more than 60+ reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Created various Weekly and Monthly reports showing detailed information.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Implemented Unit Tests and Integration Tests.
• Prepared documentation related to database design, objects security and rules.

Environment: SQL Server 2008R2/2005, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS,SSAS, T-SQL, Windows 2000/XP, SharePoint server 2007.

Confidential, Atlanta, GA

SQL Server BI Developer

Responsibilities:

• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created ETL packages to call the XML web service through Execute Process Task in the Control Flow.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into stage tables by performing different kinds of transformations using SSIS/DTS packages
• Created another set of ETL packages to load the data from Stage Tables to Main Table and used referential integrity model.
• Created data loads and Upgrade scripts for data migrations and validations
• Worked with different methods of logging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Have deployed packages on different servers by configuring it.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Created various Weekly and Monthly reports showing detailed information.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Implemented Unit Tests and Integration Tests.
• Prepared documentation related to database design, objects security and rules.

Environment: SQL Server 2008R2/ 2005, Query Analyzer, TFS, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2008/2000/XP, Toad for Oracle 11g,SharePoint server 2010.

Confidential, NJ

SQL Server BI Developer

Responsibilities:

• Played a dynamic role during the requirements gathering, analyzing, planning, designing and development of Business Applications.
• Developed planning strategy for Departments and Stores which includes determining group rankings, sales forecasting method, and historical planning basis to produce accurate sales plans.
• Monitor the Departments and Stores sales performance against plan to identify trends and store plans that need to be revised and forecasted.
• Active participant in the planning process with the Head of Planning and Buyers by providing historical data and analysis to verify the plans are consistent with the store's sales potential and meet the inventory receipt requirements.
• Independently developed applications and custom interactive reports in MS Excel.
• Developed macros to fetch data from different data sources.
• Developed SSIS packages to import data into Access from Excel files & other data sources.
• Worked on data models for the multi-dimensional databases and warehouses.
• Developed SSIS Packages scripts to extract data from the numerous data sources.
• Created and restored SSAS database backups from development to production servers.
• Used several types of data sources for connecting to different databases and files.
• Calculate OTB at a weekly, Monthly and Seasonal level based on Sales, Markdowns, on order and Inventory.
• Key Role in designing the Report Templates according to the requirements in efficient and user friendly approach.
• Developed and generated Daily, Weekly, Monthly, Quarterly and Yearly Planning and Forecasting Reports with the help of Excel Macros.
• Used Microsoft Excel to extract data from the complex cube structure (SSAS) in the form of Pivot Tables.
• Used Microsoft ProClarity for ad-hoc reporting.
• Used TSQL Statement to query data when needed.
• Analyzed and wrote complex formulas in Microsoft Excel 2007.

Environment: SQL Server 2008R2/ 2005, MS Excel 2007, Query Analyzer, DTS, SSIS, SSAS, T-SQL, Windows 2008/2000/XP.

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in different stages of Project Life Cycle.
• Actively participated in gathering Business Requirements and System Specifications.
• Created new Databases, tables, established relationship among tables in a database.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Indexes.
• Used SQL Server System Catalog to find Stored Proc, UDF, Triggers, indexes and constraints on existing databases.
• Implemented batch processing using Jobs and DTS.
• Migrated data from Flat files to SQL server 2000 using DTS (Import and Export Wizard)
• Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Scheduled Jobs using SQL Server Agent.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Designed and implemented several complex reports.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using crystal Reports.
• Created different user level groups, and assigned appropriate permission level to the database.
• Preparation of project documentation.

Environment: SQL Server 2000/2005, DTS, MS Access, MS EXCEL, T-SQL, Windows 2000 server.

Confidential

MS SQL Server Developer

Responsibilities:

• Installation and administration of MS SQL Server 2000 and Windows 2000.
• Coding complex SQL Stored procedures according to the Specs Joining the different tables and conditions.
• Conducted database management, performance measurement and tuning for new and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Created the Temp tables in the stored procedure for different application.
• Wrote stored procedures and T-SQL code to accomplish various tasks.
• Created different functions in the application.
• Created the index to increase the performance of stored procedure.
• Created the batch stored procedures for the Report Scheduler according to the monthly, weekly or daily.
• Created database tables, constraints and indexes.
• Involved in performing a data mapping, quality assessment converting multiple databases for all product types.
• Partitioned tables which had frequent inserts, deletes and updates to improve the overall performance.
• Set up the DTS package for importing and exporting data to and from SQL Server.
• Used DTS to convert Excel data to SQL Server 2000.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: MS SQL Server 2000, T-SQL, SQL Server Enterprise Manager, SQL Profiler, Excel, Data Import, DBMS, C.