EXECUTIVE SUMMARY:

• 5+ years of experience in analysis, design, development and maintenance in IT industry.
• Participated in all phases of SDLC starting from Analysis to Delivery of the application development projects and also supported enhancements and maintenance of existing applications.
• Extensive knowledge of SQL reporting, business intelligence and analytics.
• Experience in index design and T - SQL performance tuning techniques and T-SQL coding methods and best practices.
• Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T-SQL.
• Experience in SQL Server 2012/2008 database development and data migration.
• Performed unit level testing based on unit test case documents prepared from requirements.
• Experience in writing SQL queries and optimizing the queries in SQL Server 2008.
• Performed data analysis and data profiling using SQL on various sources systems.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services SSIS.
• Experience in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

PROFESSIONAL SKILLS:

Reporting Tools: SQL Server Reporting Services 2012/2014 R2, MicroStrategy 10.8

Internet Technologies: HTML, JavaScript, VB Script, ASP.NET 4.0/3.5

RDBMS: SQL Server 2012/2014 R2, SSMS, Oracle 10g/11g, Toad 9.7

ETL Tools: SSIS 2012/2008 R2/2005

GUI: Visual Studio 2012/2008 (BID s Tool)

Operating Systems: Windows Server 2008 R2/2003, Windows 7 PRO/XP

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

SQL BI Developer

Responsibilities:

• Involved in Planning, design, and implement database objects, such as tables, stored procs and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Writing Queries, Stored Procedures, Triggers, Functions and Views as per requirement
• Creating and managing schema objects such as tables, views, indexes and stored procedures
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used different transformations (derived column, conditional split, merge join, sort, lookup etc.…) and Tasks (data flow task, executive SQL task, email task, script task etc.…) in SSIS packages
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load in to Data mart.
• Used TFS server for version control for SSIS packages
• Extract data from database using with SQL scripts and uploaded to excel file and send it users.
• Promoting SSIS packages, stored procedures, views and tables from one environment to another environment.

Environment: MS SQL Server2012/2008, Team Foundation Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2012/2008(BIDS Tool), Windows XP, SQL Server Management Studio (SSMS). MS Office 2010.

Confidential, Miami, FL

Business Intelligence Developer

Responsibilities:

• Created and maintained clearly written technical, user, and system documentation.
• Worked with complex SQL, Stored Procedures, Triggers and packages in very large databases from various servers.
• Created User Interface reports for validating the Data through Reporting Services.
• Highly responsible for development and management of SSRS and SSIS projects.
• Extracting and Loading data from different sources into SQL Server Database using with SSIS.
• Extensively involved in designing the SSIS packages to export data from SQL Server database to .csv files for user validations.
• Scheduling & Maintaining ETL packages in terms of data validation and consistency.
• Created Mapping, Design and technical Documentation for complex SSIS packages.
• Experience in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.
• Involved in Maintaining Database with Backup, Restore Strategies and scheduling those backups using SSIS packages as a Developer.
• Deployed many packages on different servers using SSIS package Configurations.
• Involved in Backup and Restoring the Databases.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, lookup, Derived Column task and Script Task in SSIS Designer.
• Responsible for scheduling the packages through Jobs for daily and weekly runs.

Environment: SQL Server 2008 R2, Team Foundation Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Oracle 10g, Visual Studio 2008 R2 (BIDS Tool), Windows XP, SQL Server Management Studio (SSMS). MS Office 2010.

Confidential, St. Louis, MO

SQL BI Developer

Responsibilities:

• Involved in gathering requirements, worked closely with business users and implemented logical and physical modeling using Erwin.
• Created Database Objects like Tables, Stored Procedures and Views
• Created complex queries involving CTE’s, Sub-queries and Joins.
• Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization using execution plan.
• Created new database/tables to put in the extracted data and rebuild the relationship.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Created the SSIS packages and scheduled them using SQL Server agent.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Deployed SSIS Packages from Dev/Staging/Production using Package Configurations
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• Developed drill-through and drill-down reports using SSRS. Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different locations.
• Responsible for scheduling the packages and stored procedures through SQL agent Job for daily runs.

Environment: SQL Server 2008, MS Office 2010, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Visual Studio 2008(BIDS Tool), SQL Server Management Studio (SSMS).

Confidential, Dallas, TX

SQL BI Developer

Responsibilities:

• Worked with Business Analysts to understand the requirements. Analyze different business requirements and provide time estimate for all SDLC phases (Analysis, Design, Coding, Implementation, SIT, UAT, and Production Move).
• Perform ETL processes using SSIS tool for SQL Server
• Design/Develop complex queries efficiently as per the given business requirements.
• Created database fact/dimension tables, views, stored procedures, functions and triggers as required.
• Worked on Table Partitioning to load current and historical data.
• Worked with Business users to understand the Business Logics as per the need.
• Developed views, sub-queries and joins for complex queries involving multiple tables Created joins and sub-queries for complex queries involving multiple tables.
• Used various transformation tasks to create ETL packages for data conversion.
• Loaded flat files data into database using SQL Server Integration Services (SSIS), after applied various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Created Transact-SQL (stored procedures, views, triggers, sub-queries, joins)
• Generated reports using SQL server reporting services (SSRS).
• Scheduled Jobs and Alerting using SQL Server Agent.
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Used SQL Server Reporting Services (SSRS) for creating matrix and tabular, drill down, drill through, and parameterized reports based on the requirements.
• Worked with DBAs to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
• Generated various reports like parameterized, drill down, drill through, sub reports using SQL Server Reporting Services (SSRS) for various projects.
• Perform /coordinated end to end Migration process in TEST /PROD ENV.

Environment: SQL Server 2008, MS Office 2010, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Visual Studio 2008(BIDS Tool), SQL Server Management Studio (SSMS).