SUMMARY

• A result oriented and skillful professional having excellent knowledge of IT sector possesses 7 years of Experience in Data Warehousing, Database Design and ETL Processes in the Development, Test and Production environments.
• Excellence at providing comprehensive Database Design, Development and business intelligence of Microsoft SQL Server 2012/ 2008/2005.
• Excellent Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Proficient in Development, Implementation, Administration and Support of ETL processes for Large - scale Data warehouses using SSIS.
• Excellent Knowledge in database and data warehousing concepts (OLTP & OLAP).
• Developing reports on SSAS&SSRS on SQL Server (2005/2008 R2/2012).
• Excellent Knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Strong Knowledge in writing Database objects (Stored Procedures, Functions, and Triggers).
• Excellent grasp of data warehousing and such processes as extracting, transforming and loading.
• Strong Knowledge in migrating data from external system including flat files, excel, MS Access and Oracle into SQL Server using SSIS packages.
• Rich exposure to System Development Life Cycle (SDLC).
• Good understanding of Microsoft ReportingService(SSRS)with Report authoring, Report management, Report delivery and Report security.
• Involved in Designing Developing and Testing of the ETL strategy to populate the data from various source systems.
• Hands on Experience in .Net Technologies like ASP.Net, ADO.Net and C #.
• Expertise in designing Data Flow task and Control Flow task on SSIS.
• Experience in Dimensional Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Proficient in Data Warehousing and Cube designing in Business Intelligence Development Studio.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Expertise in migrating data from MS-Access, MS-Excel and other external data sources.
• Analytical thinker that consistently resolves ongoing issues or defects, often called upon to consult on problems that have eluded resolution by others.
• Experience with Unit Testing, Integration Testing and Load testing in the modules according to the requirement and development standards.
• Strong interpersonal and communication skills with an ability to lead a team and keep them motivated.

TECHNICAL SKILLS

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

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, Database Tuning Advisor, SQL Profiler, Enterprise Manager, Query Analyzer.

ETL Tools: SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS)

Reporting Tools: SQL Server Reporting Services 2012/2008/2005 (SSRS)

OLAP Tools: SQL Server Analysis Services 2012/2008/2005

Programming Languages: SQL, T-SQL, C, C++,C#, Asp .Net

Operating Systems: UNIX, Windows (NT/2000/XP/Vista/7/8), Windows Server ( 2005/2008/2012 )

Packages: Microsoft Office

Web Development Tool: HTML, XML, JavaScript, CSS, PHP

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

SQL/ BI Developer

Responsibilities:

• Develop ETL Packages and Reports.
• Create tables, stored procedures when required.
• Served as the primary point of contact for most of the Enterprise Business intelligence design and development.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2008 and 2012 Integration services.
• Analyze business data using Toad software on Oracle
• Hands on experience in using different transformations like data Conversions, lookups, Derived column transformations etc. for data cleansing to remove unnecessary columns, eliminate redundant, inconsistent data and unnecessary Data like removing empty rows using SSIS.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Create databases, tables, and fields for data entry, performing database capacity planning.
• Enhancing and deploying the SSIS packages from development server to production server and scheduled jobs. Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment: SQL Server 2008/2012, SQL* Plus, MS Word, MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server 2005/2008, ASP.NET, BIDS 2005/2008,Visual Studio 2005/2008/2012 , TFS, Toad

SQL/BI Developer

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created SQL joins, Sub queries, tracing and performance tuning for better running of queries.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, List items, Charts and Linked reports.
• Created and designed reports based on query parameters and Report parameters.
• Created nested Grouping, sorting columns and writing expressions according to the business requirements.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions to migrate data from staging to production environment
• Modified existing stored procedures, functions using joins following SQL Standards to enhance the performance of the reports.
• Experience with Indexing, normalization and query optimization.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Generated Custom ETL scripts using SSIS, develops and unit test SSIS load processes for performance check.
• Created Reports on Performance Point Server 2007using SSRS,utilizing Microsoft Office Excel as the end-user interface for planning, budgeting, and forecasting.
• Good understanding of Microsoft ReportingService (SSRS) with Report authoring, Report management, Report delivery and Report security.

Environment: SQL Server 2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), OLAP, OLTP, Performance Point Server, MS Word, Erwin, ETL, Enterprise manager, Windows Server 2008.

Confidential, Atlanta, GA

MS SQL Server Developer

Responsibilities:

• Installed SQL Server 2000 on servers.
• Designed SQL Server 2000 database.
• Involved in Logical & Physical design, development and testing of the system.
• Administrated SQL Server 2000 under NT in an enterprise scale network.
• Responsible for understanding the customer requirements.
• Participated in meetings with the client and team members.
• Developed triggers and stored procedures to in corporate the business logic and process.
• Troubleshoot performance issues, fine-tuned queries and stored procedures.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Performed Data Integrity Validation.
• Developed a total of 100+ stored procedures for front-end application and reports.
• Involved in design, programming, deployment and Unit Testing of requested Reports.
• Involved in the creation of web services using VB.NET
• Designed, Developed and Deployed reports in MS SQL Server environment using SQL Server Reporting Services-2000.

Confidential, Minneapolis MN

SQL BI Developer

Responsibilities:

• Analyzing different user requirements and coming up with specifications for the various database applications.
• Developed complex T-SQL queries to migrate data from staging to production environment.
• Identifying issues with the database and resolving them.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Monitored the performance of the database and checked on the execution time.
• Primarily responsible for developing applications in SSIS as per Business Rules and features of the tool.
• Designed and maintained various types of reports like parameterized, drilldown and cascading reports using BIDS.
• Developed complex T-SQL queries to migrate data from staging to production environment.
• Modified existing stored procedures, functions using joins following SQL Standards to enhance the performance of the reports.
• Experience with Indexing, normalization and query optimization.
• Generated Custom ETL scripts using SSIS, develops and unit test SSIS load processes for performance check.
• Designed partitions in Cubes on time for improvement in performance using SSAS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created Unit Test specifications and Unit test Results.
• Implementation activities in Integration and Production.
• Confirming to all the process and standards for the projects.

Environment: SQL Server 2012/2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), OLAP, OLTP, ETL, Enterprise manager, MS Word, Windows Server 2008/2012.

Confidential

SQL BI Developer

Responsibilities:

• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using T-SQL.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2008/2005 and Integration services.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options
• Extensively worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.
• Hands on experience in using different transformations like data Conversions, lookups, Derived column transformations for data cleansing to remove unnecessary columns, eliminate redundant, inconsistent data and unnecessary Data like removing empty rows using SSIS.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Reduced the overall ETL time by SQL Query performance Tuning.
• Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Create databases, tables, and fields for data entry, performing database capacity planning.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), OLAP, OLTP, ETL, Enterprise manager, MS Word, Windows Server 2008/2005.