SUMMARY

• Around 7 years of experience in Analysis, Design, Development, Implementation and Migrating of Business Applications using the SQL Server and Oracle relational databases management system on various platforms.
• Experience with multi file systems and larger dataset (processing 5 TB every day)
• Strong expertise in analyzing and bug fixing
• Exceptional Problem solving skills
• Experience in ETL development on different environment
• Worked with Data Modeling both Physical & Logical using SQL Data modular
• Proven ability to plan, coordinate and implement Full Life Cycle of software development and maintenance projects.
• Strong expertise in Transact SQL, Oracle PL/SQL, SQL*PLUS, Pro*C, back - end programming like Packages, Functions, Stored Procedures, Database Triggers
• Experience in creation of ETL Mappings and Transformations SSIS to move data from multiple sources into target area.
• Proficient in Performance Tuning and maintain Large Volume of Data includes Oracle database/SQL Server and Data Mart.
• Created complex and simple ETL transformation using Informatica, Powercenter. Tuned the sessions and transformations in production.
• Strong in Database Design, Creation, Migration, Upgrading, Performance Tuning, Logical and Physical Design, Database Tuning, Backup and Recovery Activities, Installation and Upgrade of Database.
• Experience in migrating the data from Legacy system to SQL Server / Oracle Database and also involved in the upgrades.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/ 8i, MS-SQL Server 2005/2000/2008 , MS Access, Teradata, MySql

Oracle ERP: Retail Merchandising Systems (RMS), Retail Data warehouse Management (RDM)

Customized Tools: Momentis Vendor Management in SQL Server, Allocation (JDA Arthur) in Oracle PL/SQL

Languages: PL/SQL, SQL,, UNIX (K/B/C), Java, XML, SSIS/DTS PackagesDataModeling SQL Data Modular

Data Warehousing: Ab Initio, ETL/Informatica 7/7.1, AWM, ADDM.

Tools: Erwin 4.0, Developer 2000/6i/9i, Forms 6i, Reports 6i, TOAD, SQL*Plus, SQL*Loader, Explain Plan, Import/Export,, MS OFFICE

Reporting Tools: Business Objects XI/5(BOXI)

OperatingSystem: Sun Solaris, Windows 9x/2000/NT

PROFESSIONAL EXPERIENCE

Confidential, West Des Moines IA

Database Developer/Analyst

Responsibilities:

• Created the complex SSIS Package in Bisiness Intelengence Development Studio(BIDS)
• Extract Transformed and loading(ETL) to the newly built loading table
• Scrubbed the attributes from various source system and mapped with destination
• Created the database tables to load the data from different sources and updated based on business rules
• Pulled the data from various source like SQL server, Oracle and Teradata
• Created the required attributes based on the Micro strategy team since the reporting has to be shifted from SAS to Micro Strategy
• Identifying the sources attributes required by reporting team and mapped as per business requirements.
• Worked in Unit testing for the SSIS package before deploying to testing team
• Gathered requirements consulting with Micro Strategy team and update accordingly
• Worked on Teradata to capture the records and executed the result to determine for new platform.
• Used Oracle as a source for capturing the records and mapped with destination newly built server
• Scrubbed the attributes and set the status to track the Mortgage records
• Updated Mortgage data, loan data, sales data from various source as SQL, Teradata and Oracle
• Participated in code reviews, Team Meeting and in corporate the comments for development
• Followed the SSIS process flow designed by system analyst to get the scope of the project
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

Environment: SQL Server Management Studio 2008, Microsoft visual studio 2010, Business Intelegence Development Studio 2010, Teradata Client/ SQL Assistance 14.1, TOAD, Microsoft office 2010, windows server 2008, Windows 2000/XP/NT.

Confidential, Maryland

SQL Developer/ Programmer

Responsibilities:

• Very Strong hands-on experience with PL SQL debugging
• Worked as SQL programmer with hands on experience in writing complex stored procedures and packages.
• Worked on existing framework procedures and packages with new business logics.
• Commented on complex and huge package of approximately 7800 lines as per the business requirement
• Analyzed the business requirement and gave feedback to the team.
• Involved in code testing and peer evaluation.
• Worked with QA team for knowledge transfer of development for testing.
• Analyzed the systems, business units in order to define the requirements, while working with Business Analysts.
• Developed and supported multiple applications on oracle and SQL
• Worked with data modeling (Facts and Dimensions table) and Entity Relationship
• Created database objects like tables, views and writing joins and sub queries
• Bug fixing
• Participated in code peer reviews and ensure the code written complies with the company standards
• Participated in meetings and discussions with functional/ technical leads to understand the requirements and work out the design
• Worked with test team to resolve back end related issues
• Worked in agile/Iterative development and MMIS environment

Environment: SQL Server Management Studio 2008, Oracle 11g, TOAD, SQL*PlusScripts, Sun Solaris 9/8, Windows 2000/NT., Microsoft office 2010

Confidential, South San Francisco, CA

SQL Server Developer/Data Analyst

Responsibilities:

• Very Strong hands-on experience with SQL (Sql Server and Oracle)
• Worked through the existing data analyze to find gaps and leaks and document the end to end flow.
• Worked with heterogeneous database, excel files and flat files
• Developed Business Objects reports and excel reports
• Strong knowledge of Master Data Management(MDM) system
• Analyzed thousands of SQL complex queries and explain to end to end flow
• Report the findings to the team
• Updates the database hubs, create extracts, back up log files and DB tables
• Worked with DataFlux jobs and analyzed for end to end flow.
• Analyzed Merge and split of the records from source systems
• Worked for standardization of attributes in the database
• Worked with clients to identify business objectives and to define workflow and business process changes
• Gathered information and developed mapping based on the requirements.
• Strong expertise with communicating and working with Business System Analysts and Business Users
• Strong analytical and problem-solving skills
• Created complex SSIS package to capture the records from various sources
• Extracted the source system files from various source and mapped with destination using SSIS
• Worked through process flow to get the scope of SSIS project
• Expert in creating Star schema cubes using SSAS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Environment: SQL server Management studio 2008, DF power studio version 8.2, df power architect 8.2, windows 2007, Microsoft visual studio 2008(SSIS)

Confidential, San Francisco, CA

SQL Developer/Data Analyst

Responsibilities:

• Extensive work experience with SQL Server as a part of database development team
• Worked closely with Business Analyst for bug fixing and reporting on Business Objects and Excel
• Developed and coded multiple SSIS dataflow for CRM (Customer Relationship model), Vendor Management and Purchase Order models
• Worked with SSIS tasks, data flow objects, in SSIS
• Created stored triggers, procedures and functions as required in Oracle Pl/Sql and T-Sql
• Worked with heterogeneous database, excel files and flat files on SSIS
• Owned multiple SSIS packages and gave support to the same
• Working Knowledge on Microsoft Visual Studio.
• Worked on both Unix and Windows operating system
• Worked with secure FTP for transferring the files
• Was primary point of contact for major models
• Worked on scheduling the packages on windows(Windows scheduler) and unix (crontab)
• Gave multiple bug fixes for existing packages based on the user requirement
• Worked with tuning of SSIS packages for better performance
• Worked with VB script and T-sql packages within SSIS
• Developed Business Objects reports and excel reports
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS

Environment: Oracle 10g/9i/8, PL/SQL, ETL, SQl Server 2005/2000, TOAD, SQL*Plus, Shell Scripts, Windows 2000/NT, Business Objects XI, Microsoft Visual Studio 2008.

Confidential, San Jose, CA

SQL Developer/Data Analyst

Responsibilities:

• Extensive work experience with Ab Initio GDE as a part of UBI team (User Behavior Intelligent)
• Developed multi partition/parallel graphs based on business requirements to process around 5TB of daily data
• Worked with map tuning and gave support and maintained the production maps.
• Worked with transformations like aggregator, update strategy, connected and unconnected lookups, filter and routers based on the requirements.
• Designed and developed Ab Initio graphs for analytical/investigation purposes
• Worked with high volume data set
• Used FTP and secure FTP in shell scripts to transfer multi files to different servers
• Extensively Worked with Microsoft Visual Studio 2008.
• Worked with data modeling (Facts and Dimensions table)
• Oracle and Teradata databases used as source for GDE along with multi files
• Gathered information and developed mapping based on the requirements.
• Worked with multiple components like scan, scan with rollup, gather, sort, filter by expression etc in GDE
• Used Ab Initio programming language to process large amounts of data in GDE
• Developed perl scripts to generate files to be used by Ab Initio GDE
• Worked with clients to identify business objectives and to define workflow and business process changes
• Provide on-going development and production support for data pull, utilizing Ab Initio and SQL
• Wrote and updated technical documentation
• Prepared and executed unit and integration test plans
• Supported and maintained existing graphs

Environment: Microsoft Visual Studio 2008, Ab Initio GDE, Teradata client SQL Assistant, Oracle 10g, ETL, MySql, SQL*Plus,, Sun Solaris 9/8, AIX, Windows 2000/NT, perl

Confidential, San Francisco, CA

System Analyst and SQL Developer

Responsibilities:

• Developed and Supported multiple applications SQL Server
• Migrated Sales Audit application from Oracle 9i to 10g with improved performance
• Migrated Purchase Order and Vendor Management related applications from Sql Server 2000 to 2005
• Developed and Upgraded DTS packages to SSIS from SQL Server 2000 to 2005
• Experience in guiding and developing various business processes(ETL) on these applications
• Strong expertise with communicating and working with Business System Analysts and Business Users
• Strong analytical and problem-solving skills
• Prepared technical Specifications and Unit Test Plans
• Responsible for integration of Oracle Retail products with Legacy systems
• Excellent knowledge of Oracle queries and Pl/Sql coding
• Wrote PL/SQL procedures, packages and triggers as required
• Participated in Conference Room Pilots (CRP’s)
• Excellent knowledge of Transact SQL and developing Procedures, Triggers using transact SQL
• Developed and Migrated DTS Packages using VB script, Batch scripts, Linked servers and Transact SQL
• Maintained the users, address groups and classifications of DTS/SSIS packages
• Strong knowledge and understanding of structured analysis and technical design techniques
• Strong working knowledge in inventory control, Merchandising, Sales audit, Purchasing, Shipping and Order Management
• Expertise in working PCI compliance systems
• Designed and Developed Real time data ETL from sql server to oracle using e*gate util (Eways) (with XML Publication and Java )
• Build small data warehouse to populate data from transaction tables, Optimized for reporting
• Scheduling jobs windows scheduler
• Performed software Unit Testing and wrote Test cases as required
• Excel programming (VB Script) to access data and validating data
• Documenting and writing design document after collecting the requirement from Business users
• Developing ETL Process for a large database from Oracle to SQL Server and vice versa
• Analyzed the systems, business units in order to define the requirements, while working with Business Analysts.
• Debugging, bug fixing and to provide the patch to end user for the problem fix.
• Preparation of technical specifications for the development of Extraction, Transformation and Loading (ETL) mappings to load data into various tables and defining ETL standards.
• Developed stored procedures and triggers for the back end interfaces using PL/SQL.
• Performance tuning of the database and its objects.
• Perform exports/imports of the database and creating views and Materialized views
• Creating and Managing primary data base objects such as Tables, Views, Indexes, Sequences, and Synonyms.
• Involved in Logical & Physical Database Layout Design.
• Provided user training and production support.
• Worked in EAM( Enterprise Assets Management) v 10

Environment:, SQL Server 2005/2000/7Oracle 11g/10g/9i/8, PL/SQL, ETL, Sql Server 2005/2000/7, TOAD, SQL*Plus, Shell Scripts, Sun Solaris 9/8, AIX, Windows 2000/NT, Momentis, Sales Audit, Forms 6i, Business Objects XI/5, Microstatergy

Confidential, Mountain View, CA

Database Developer (Consultant)

Responsibilities:

• Analyzed the systems, business units in order to define the requirements, while working with Business Analysts.
• Developed Mappings using various transformations like connected/unconnected Lookups, Filters, Aggregators, Update strategy, Routers, Joiners depending upon requirement in the Informatica Designer
• Wrote PL/SQL procedures, packages, triggers and Oracle Forms as required.
• Preparation of technical specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables and defining ETL standards.
• Developed stored procedures and triggers for the back end interfaces using PL/SQL.
• Good knowledge of Pricing, Inventory and Purchase Order process
• Performance tuning of the database and its objects.
• Perform exports/imports of the database
• Performed Unit Testing and wrote test cases as required.
• Wrote user documents on ETL scripts
• Experience in developing HTML Pages
• Creating and Managing primary data base objects such as Tables, Views, Indexes, Sequences, Synonyms.
• Involved in Logical & Physical Database Layout Design.
• Configured tnsnames.ora and listener.ora for multiple Oracle Homes for windows as well as unix.
• Extensively worked in Workflow Manager and in the performance tuning of the ETL programs and processes.
• Wrote Korn Shell and Bourne Shell Scripts for retrieving data from Oracle Database.
• Worked on some of the DBA support tasks and used metalink to solve problems.
• Helped design DDL scripts for data loading using DBlink and created DBlink for the same.
• Created scripts for tablespaces, users, and roles for application and owned them.

Environment: Oracle 9i, PL/SQL, Informatica Powercenter 7.1, ETL, TOAD, SQL*Plus, Perl/Shell Scripts, Sun Solaris 9/8, HP-UX, Windows 2000/NT.