SUMMARY:

• 12 Years of IT Experience in Database Design, Development, ETL Implementation and support in OLTP/Data warehousing of Microsoft SQL Server 2012/2008R 2/2008/2005/2000 in various SDLC environments
• Solid Knowledge in Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manger)
• Experience in various Business Domains like Finance, Insurance, Pharmacy and Health Care dealing with High transactional, Multi - Server Production Environment
• Extensively worked on Data Modeling, Normalization and De-Normalization Technique for both OLTP and OLAP systems.
• All activities related to the development, implementation, administration and support of ETL processes
• Experienced in writing SQL, T-SQL Commands, Stored procedures, Triggers and Functions in MS SQL Server 2000/2005/2008 R2
• Implemented SQL Server Indexing, Index Tuning using Index Tuning Wizard and Tuning Advisor.
• Excellent knowledge in Performance Tuning and Query Optimization using SQL Profiler, Execution Plan, Performance Monitor
• Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Data refreshes, Security and User management, Performance Tuning, Replication process like transactional, snapshot and also Mirroring Databases
• Involved in Security Administration, managing Schemas (2008), creating Credentials, creation of Users, Configuring Permissions and Assigning roles to users and Security Settings

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2000/20 R2/2012, MS Access 97/2003/2005/2008, Oracle 8i/9i/10g, Sybase, PL/SQL, MS SQL, SQL*Plus, Teradata V2R5

Language: T-SQL, PL/SQL, MDX, C, ASP.NET, VB.NET, Unix Shell Script

Tools: &Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Crystal Reports9.0, Visual SourceSafe6.0, Visual Studio .NET, Informatica Power Center, Active Batch, Jira, Confluence, TOAD

Operating Systems: Windows 7/vista/XP/2003/2000, Windows Server 2000/2003/2008, Unix.

BI Tools: Data Transformation Service (DTS), SQL Server Reporting Tool (SSRS), SQL Server Integration Service (SSIS), Informatica Power Center, SQL Server Analytical Service (SSAS), MS Visio, Erwin, Crystal Reports.

Web Technologies: HTML, DHTML, XML, VB Script

Application Packages: MS Office, MS Outlook, Windows SharePoint Services.

PROFESSIONAL EXPERIENCE:

Confidential, El Segundo, CA

ETL Developer

Responsibilities:

• ETL development, testing, implementation, and support of integration solutions.
• Support ETL and Data Warehouse production, development & test environments.
• Creating and amending programs in accordance with the design following relevant code management procedures and applying agreed coding standards.
• Develop key integrations with both internal and external systems.
• Collaborate with team members to prototype, test, and debug code which will provide data for use in business reports.
• Conversion/Migration of data into new systems.
• Data analysis, data mapping, data loading, and data validation.
• Worked on analyzing various ETL’s to understand the underlying rules and implemented best alternatives.

Environment: SQL Server 2008/2008R2/2012 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Microsoft Visual studio 2008/2010, Crystal Reports, PL/SQL, T-SQL, XML, Microsoft Visual Source Safe, TFS (Team Foundation Server), MS Access 2003 & Windows Server 2003, VB Script, Informactica 10, Active Batch, Atlassian.

Confidential, Torrance, CA

ETL Developer

Responsibilities:

• Working with business users and business analyst for requirements gathering and business analysis.
• Converted business requirement into high level and low level design.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
• Worked on Informatica Power Center 8.6 tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• Used Normalizer transformation with COBOL sources stored in DB2.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Created sequential batches and concurrent batches for sessions.
• Developed PL/SQL procedures/packages to kick off the SQL Loader control files/procedures to load the data into Oracle.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Supporting daily loads and work with business users to handle rejected data.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes.
• Executing test scripts to verify actual results against expected results by using Power Connect for source (DB2) validation and Oracle for target validations.

Environment: SQL Server 2008/2008R2/2012 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Microsoft Visual studio 2008/2010, Crystal Reports, PL/SQL, T-SQL, XML, Microsoft Visual Source Safe, TFS (Team Foundation Server), MS Access 2003 & Windows Server 2003, VB Script.

Confidential

SQL Developer

Responsibilities:

• Involved in Creating Database Objects like Tables, Stored Procedures, Views, Triggers, and user defined functions for this project
• Analyze the client requirements and translate them into technical requirements
• Gathered Requirements from the end user and involved in developing logical model and implementing requirements in SQL Server 2000
• Experience in DTS for data flow from source files like Excel, Tables, and Views to other databases or files with proper mapping
• Designed DTS package, with DTS Import/Export wizard for transferring data
• Data migration (Import & Export - BCP) from text to SQL Server
• Responsible for creating reports based on the requirements using Reporting Services 2000/2005
• Identified the database tables for defining the queries for the reports
• Defined report layouts for formatting the report design as per the need
• Identified and defined the Datasets for report generation
• Wrote queries for drill down reports to get the dataset required to build the report
• Deployed generated reports onto the Report Server to access it through browser
• Maintained data integrity by performing validation checks
• Optimized queries, tuned and monitored server performance

Environment: MS SQL 2000/2005, Windows server 2000, SQL Query Analyzer and Enterprise Manager, MS Access 2000 & Windows NT platform.