SUMMARY

• Over 5 years of experience in information technology industry with extensive IT operations experience emphasizing Requirements Analysis, Design, Development, Integration and maintenance.
• Mostly, work on MSBI - 2008/12 (SSIS and SSRS) with sophisticated technical skills in Design ELT and Reports.
• Extensively involved in T-SQL, procedures, functions, views and implement best practices to maintain optimal performance.
• Experienced in using Data Modeling Tools ERwin and Microsoft Visio.
• Work with DB developers, MSBI and systems support personnel in elevating and automating successful code to production.
• Involved in the deployment process of SSIS/SSRS and MSSQL objects for different environment (SIT/UAT/PROD) and maintaining/monitoring on Higher to lower level environment server.
• Holding good knowledge on building OLAP Cube and MDX query language in SSAS.
• Worked on optimization in T-SQL programming to optimize Stored Procedures, Functions/indexes.
• Good knowledge in DBA Skills (Backup, Restore & SQL Jobs configuration. Database Performance/optimization Tuning, index rebuilding and reorganize etc.
• Experience in Adding or modifying Users, Groups and folders using Report server and Team Foundation Server.
• Efficient in migration from SQL Server 2000 to SQL Server 2005/2008/R2/2012.
• Quick learner and good performer both in team and independent job environments.
• Good at installation and configuration of SQL Server 2008 and 2012.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008R2/2008/2005, MS - Access, Oracle, DB2

SQL Server Tools: MS SQL Server2008R2/2008/2005, MS-Access, SQL Server, Business Intelligence & Development Studio, MS Visio

Programming Languages: T-SQL, VB.net

Operating Systems: Windows Server 2000/2003/2008 R2, Windows XP/7, UNIX.

Web Technologies and Software: CSS, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Corona, CA

SQL DEVELOPER

Responsibilities:

• Successfully, Implemented ETL Packages to load Data in Data warehouse and optimized OLTP database.
• Actively involved in the development/deployment of ETL packages in MSSQL 2012 to load OLTP Data.
• Involved in formulated queries in T-SQL in meeting reporting needs.
• Formulate Implementation Design/technical document, and mapping document base on business logic.
• Benefitted handling brainstorming discussions design, development process and deployment of SSIS projects.
• Integrated SSRS reports to SharePoint portal using Report Viewer Web Part.
• Supporting multiple projects, assigning the tasks to team and being responsible for coordinating with off-shore.
• Responsible for deciding the goals based on the designation.
• Proactively, associated with the business users to jointly come up with initial user requirements.
• Formulated High Level Design Reviews with business Client and implementation of the Low Level Design documents.
• Working as an individual contribution from onshore in INI (Insurance and Investment) application development and production support and direct reporting to Off-Shore development Team.
• Involved the development of database including SQL views, function and stored procedures.
• Successfully, developed packages that have dynamic configuration and Error event handling using On Error, SSIS Logging and has Failure email notification as well as storing SSIS error log into tables.
• Steered the process of deployment of packages and configured in SQL Server Agent job.
• Accountable for building Package deployments and package Configurations.
• Play a pivotal role in the ETL team global support and Development.
• Monitoring Daily SQL Server agent jobs on production server as part of the production support.
• Involve in designing the reports with month, weekly and daily home loan metrics for Analytics and Reporting team.

Environment: SQL Server 2012, SSIS and SSRS-2012, MS Excel, Flat Files, Oracle, DB2

Confidential, San Francisco, CA

Sql developer

Responsibilities:

• Prepared High Level Design Reviews with business Client and implementation of the Design documents.
• Involved the development of database including Sql views, function and stored procedures.
• Instrumental on developing SSIS Packages to pull data from different sources and dump into ODS.
• Successfully, developed packages that have dynamic configuration and Error event handling using On Error and On Post Execution, SSIS Logging and has Success/Failure email notification as well as storing SSIS error log into tables.
• Developed, monitored and deployed SSIS packages for data warehouse solution.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Migrated data from various data sources using SSIS Transformations like Aggregate, Lookup, Conditional-split, Merge Join and Sort.
• Performing source system analysis and development of ETL jobs to migrate data from the Source to the Target Data warehouse and documented source to target mapping.
• Migrated data from various data sources using SSIS Transformations like Aggregate, Lookup, Conditional-split, Merge Join and Sort.
• Steered the process of deployment of packages and configured in SQL agent job.
• Created Report Models to design ad-hoc reports on Report Builder 1.0.

Environment: SQL Server 2008, SSIS, SSRS 2008 and Report Model 1.0, SharePoint 2007

Confidential, Richmond, VA

Sql developer

Responsibilities:

• Involved in Low Level Design based on Requirement Documents.
• Used Joins, sub-queries, Stored Procedures and Indexes for complex queries involving multiple tables from different databases.
• Involved in writing T-SQL Queries to Insert/Update data into the tables.
• Used various SSIS tasks such as Conditional Split, Derived Column and Slowly Changing Transformation which were used for Data validation checks during Staging.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Involved the development of database including SQL function, procedures.
• Successfully, developed packages to dump raw data to SQL Server database as part of ETL process.
• Developed Daily, Weekly, and Monthly reports on SSRS.
• Involved in Deployment process to Report Server on Dev and QA.

Environment: SQL Server 2008, MSBI-2008 (SSIS and SSRS)

Confidential, Cedar Rapids, IA

SQL Developer

Responsibilities:

• Created ETL packages using SSISfor data cleansing and loading to the destination.
• Involved in DB design using Kimball Methodology, Designed Dimensions, and Facts tables as per the business need.
• Created Stored Procedures and Functions
• Actively involved in designing the indexes as per requirement.
• Developed Reports Using SSRS on statistical data during migration of data.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS
• Deploying and scheduling Reports usingSSRSto generate all daily, weekly, monthly and quarterly Reports including current status.

Environment: SQL Server 2008/2005, Windows 2003 Server, SSRS, SSIS, MS Visual Studio, VB.Net