SUMMARY

• 8 Years of IT experience in Data Warehousing - Business Intelligence, MS SQL Server Developer 2008 R 2/2008/2005/2000 , ETL - SSIS Design-Architect, Production Support, Testing, Administration, .Net(DotNet) application system in various Industry verticals like Banking, Finance, Health care and Manufacturing.
• Basic working knowledge of SQL Server 2012 and SQL Server Integration Services 2012.
• Experienced in developing teh applications usingT-SQL Programming (DDL, DML, TCL and DCL). Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems
• Extensive working experience in Star schema and Snow flake schema based data warehouse design.
• Experienced in Onsite (USA, Singapore- Credit Card Historical data management and Taiwan - Credit Card Historical data management)-off shore Software Development and Implementation Methodology
• Good exposure with teh .Net(DotNet) application system to implementation perspective handling teh issues with teh workaround by using SQL scripts until getting teh permanent FIX from web application development team. IIS, WCF Service, Windows Service using making teh application high availability.
• Good Data Modeling experience (Relational/Dimensional) using tools like Visio, SQL Diagrams.
• Extensive experience in MS SQL Server 2008 R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS), Performance Point Server (PPS), VISIO, Control-M and Advance Help Desk.
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into teh Data warehouse from Heterogeneous data sources such as SQL Server, Oracle, Excel and MS Access, CSV, flat file.
• Strong experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience in creating Jobs, Alerts, SQL Server Agent and Scheduled SSIS Packages. Experienced in designing and developing large number of enterprise reports (SSRS Reports) using teh data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Excellent experience in implementing Key Performance Indicator (KPI) objects in SSAS and creating calculate members in MOLAP cube using MDX in SSAS. Expert in creating and deploying SSRS reports on teh portal for user accessibility.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting teh data, defining data sources for teh reports using SSRS.
• Strong experience in logical and physical database design and development using Visio and SQL server enterprise manager. Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.
• Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views and User Defined Functions.
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.
• Analyzing internet log files using Big Data Hive

TECHNICAL SKILLS

• MS SQL Server 2008 R 2/2008/2005/2000
• SQL Server Integration Services (SSIS)
• SSRS
• SSAS
• DataTransformation Services MS SQL Server Management Studio
• SQL Server Business Intelligence Development Studio (BIDS)
• SQL
• T-SQL
• PL/SQL
• MS Access 2007/2003
• DB2
• MySQL
• Performance Points Server 2007(PPS)
• Confidential VISIO 2003/2007/2010 for Architects
• Control-M and Advance Help Desk
• MS Visual Studio 2005/2008
• Oracle 9i
• TOAD
• Team Foundation Server (TFS)
• SDLC(Agile)
• BO XI r3 and Windows NT/2000/2003 environment.

PROFESSIONAL EXPERIENCE

Confidential, Redmond

SQL/SSIS ETL Developer

Responsibilities:

• Coordinating with teh other IT teams to collect design needs and making specialized structured written papers based on teh operative needs
• Assisting teh structural and specialized designs of teh schemes to make sure that teh judgments are being made in accordance with teh existing and forthcoming by Giant Savings">business plans of actions and chances
• Decreasing teh information repetition and division and ruling out unneeded motion of information and enhancing teh choice of information
• Producing firm explanations for joint remark information
• Making sure that teh meta information is right, legal and reclaimable
• Recognizing different matters and collecting and writing down teh needs and actions of teh scheme plans
• Owning teh architectural production actions related to ETL projects
• Helping teh by Giant Savings">enhancement of ETL request teams
• Transformed data from different data sources like different data bases to SQL Server 2008 R2 using OLE DB connection providers by creating various SSIS packages. Data is transformed to data warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for large business users.
• Migrated teh data from teh appropriate databases to end database and maintained batch log files.
• By using Deployment utility teh deployment manifest file crated to deploy teh packages in teh production server.

Confidential, Chicago, IL

Database/SSIS ETL Developer

Responsibilities:

• Coordinating with teh end user gathering to ameliorate theoverallindividual architecture expertise
• Analyzing teh Source Data
• Translating business requirement into Specification document from that converted into Database objects
• Coordinating with teh other IT teams to collect design needs and making specialized structured written papers based on teh operative needs
• Upholding a very superior level of specialized skillness on all teh operative schemes, hardware and software computer systems
• Assisting teh users and writing and producing specialized particularities
• Aiding teh support and supervision ofBI softwareprograms
• Helping teh business abled team members
• Making teh basic ETL architectural rules and regulations
• Assisting teh structural and specialized designs of teh schemes to make sure that teh judgments are being made in accordance with teh existing and forthcoming by Giant Savings">business plans of actions and chances
• Decreasing teh information repetition and division and ruling out unneeded motion of information and enhancing teh choice of information
• Producing firm explanations for joint remark information
• Making sure that teh meta information is right, legal and reclaimable
• Recognizing different matters and collecting and writing down teh needs and actions of teh scheme plans
• Owning teh architectural production actions related to ETL projects
• Helping teh by Giant Savings">enhancement of ETL request teams
• Transformed data from different data sources like different data bases to SQL Server 2008 using OLE DB connection providers by creating various SSIS packages. Data is transformed to data warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for large business users.
• Migrated teh data from teh appropriate databases to end database and maintained batch log files.
• By using Deployment utility teh deployment manifest file crated to deploy teh packages in teh production server.
• Package Configuration XML files TEMPhas created to configure teh package with server, database and credential details.
• Database backup and restore new environment creation for scenario based testing

Confidential

SQL /SSIS ETL Developer

Responsibilities:

• Validated analysis and design on assigned projects
• Analyzing teh Source Data
• Define and document best practices, standard operating and change management procedures
• Partner with teh internal user community to analyze existing systems and solutions, identify areas for process improvement and guide teh business in teh establishment of effective and efficient automated solutions.
• Facilitate teh completion of database and integration related tasks as well as teh required documentation supporting teh System Development by Giant Savings">Life Cycleand coordinate project related activities.
• Evaluate and design logical and physical databases; use modeling techniques to analyze and specify data usage within specific areas; define logical views and physical data structures
• Validates test plans and test scenarios; verify test results. Coordinate testing activities for appropriate system development team(s) with appropriate database administrators as required
• Perform problem determination (root cause analysis), and document teh source of problems and their resolution during SIT/UAT and Production. Aid customers and other staff members in resolving errors resulting from teh use of applications in teh non-production environments. Recognize and analyze trends in errors so as to identify and install long term solutions to problems.
• Involved Master Data Management and Data Quality Management.
• Independently install, configure and troubleshoot enterprise server applications such as SSIS and SSRS.
• Developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into teh Data warehouse from Heterogeneous data sources such as SQL Server, Oracle, Excel and MS Access, CSV, flat file and fixed width VISION PLUS files
• Created, configured and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Created Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages
• Scheduling TEMPhas done by using third party scheduling tool Control-M.
• Design and developing large number of SSRS reports.
• Root cause analysis for Production incidents and escalate to Service Development, Support Manager and Stack Holders based teh impact of teh customers.
• Database backup and restore new environment creation for scenario based testing
• Analyzing internet log files using Big Data Hive
• SQL azure based Data migration if teh SQL server running on teh virtual machine.

Confidential, Redwood City, CA

BI Developer

Responsibilities:

• Transformed data from different data sources like different data bases to SQL Server 2005 using OLE DB connection providers by creating various SSIS packages. Data is transformed from hub (ODS) to data warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for residential, business, large business users.
• Created SQL server Analysis Projects andcreated multi-dimensional databases and OLAP cubesand dimensions for teh analysis of capacity planning task in specific areas for departmental manager using SSAS.
• Migrated teh data from teh appropriate databases to end database and maintained batch log files. Involved in teh usage of variables to make teh packages dynamic and scheduling teh package in SSIS (sequential scheduling).
• Implemented AD HOC reporting with teh report builder for teh end users. Involved in scheduling reports to run weekly, quarterly, monthly based on teh data to be reviewed by teh manager.
• Involved in identifying and creating data sources and data source views in SSAS. Involved in Creating Dimensions and Cubes and deployed it on to teh server for teh managers to analyze teh ongoing production support for teh application as required.
• Implemented teh elements of T-SQL like dynamic stored procedure to store and update teh information regarding residential, business and large business customers into one centralized SQL database called hub.
• Enhanced teh business logic using User Defined Functions to retrieve information on teh services like billing, customer, and requests from teh residential, business and large business databases.
• Created indexes on teh database tables and generated trace events to improve teh query performance and optimize data access.
• Worked extensively with teh business, business analysts, or systems analysts to gather information needed to accurately triage and manage Online Help Desk incidents related to SQL.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of consumers.
• Database backup and restore new environment creation for scenario based testing

Environment: MS SQL Server 2008, MySQL, SSIS, SSRS, Windows XP/2003.

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in migration of SQL server 2000 to heterogeneous source using Upgrade Advisor. Installed and Configured SQL Server 2000, Created Logins, Users and Maintenance Plans managing use of Disk space, memory and connections to teh database.
• Involved in assisting QA team in deploying and testing teh application, which uses SQL Server as a database Involved in creation of stored procedures, triggers using T SQL according to teh requirement of teh projects.
• Involved in Performance tuning and optimizing for SQL Server Application by using performance monitor. Created Views to reduce database complexities for teh end users.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2000.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.

Environment: MS SQL Server 2000, T-SQL, Query Analyzer,Informatica 7.1,Oracle9i