SUMMARY

• 15+ year’s software development expert with strong track record of development experience, including 7 years designing and implementing data warehouses, data marts, and other business intelligence solutions throughout the business intelligence lifecycle.
• Solid hands on experience with Data Warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions, Problem Solving, and Process Documentation.
• Expert in managing/leading ETL and Business Intelligence Testing for supporting data extraction, transformations and loading processing, in a Confidential - wide-ETL Solution using MS SQL Server.
• Develop SSIS packages to extract data from flat files, SQL Server database and Excel to load to data warehouse. Some of the data flow transformations used include Data Conversion, Conditional Split, Lookup, Fuzzy Lookup, Slow Changing Dimension, OLE DB Command, Merge, Union All, Sort, Aggregate and more.
• Experienced as SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis/ reporting/processing.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema, designing data models using Erwin, developing SSAS Cubes, SSRS Reports.
• Strong Understanding of Database Concepts that can be used to configure the business layer and optimize to improve the performance.
• Expertise in working with SQL queries and PL/SQL (Stored Procedures, Triggers, Packages/Functions).
• Experience in delivering projects in a SOX compliant environment.
• Competent in all aspects of Data Warehousing including project planning, requirement gathering, data modeling, development, deployment, maintenance, and enhancements.
• Able to work collaboratively, quickly understand system architecture and business needs while committed to achieving Confidential goals.

TECHNICAL SKILLS

• Operating Systems: Windows (NT, 95, 98, 2000, 2007), Windows XP, Windows 7, MS DOS
• Databases: MS SQL Server 6.5/7/2000/2005/2008 , Oracle 8.1/9i/10g/6.0, MS Access, MySQL
• Query Tools: PL/SQL, Toad 7.4/8.3.6, SQL Query Analyzer, SQL Plus
• ETL Tools: Microsoft SSIS
• Modeling Tools: Star-Schema & Snowflake-FACT and Dimension Tables, Erwin
• Languages: VB Script, Java, JavaScript, C, C++, HTML, Visual Basic, ASP, XML
• Project Management tools: Microsoft Project Server.
• Reporting Tools: MS SSRS, Crystal Report 6.0/7.0, Actuate 4.0/6.0/7.0
• Others: Visual Source Safe, Heat, MKS Tool kit

PROFESSIONAL EXPERIENCE

Confidential,

Responsibilities:

• Assisted the client in creating initial business requirements specification document for the reports of the Support Service Organization.
• Analyzed the business requirement of the reports of the support service organization.
• Involved with Design Process of data modeling to dimensional modeling of the business.
• Created the mapping document to identify the report fields and corresponding Siebel fields using the Siebel tools.
• Extracted Siebel booking, assets/entitlement, opportunity and service request data using ETL tool.
• Extensive experience in developing SSIS packages to extract, transform and load (ETL) data from disparate data sources.
• Implemented all the business rules in the ETL tool using aggregate, join and selection criteria to information.
• Transformed data from raw forms into structures as per the report requirement.
• Simplified loading of data into target database through automatic invocation of bulk loaders.
• Execute, schedule, review, manage, audit and create dependencies among ETL requests
• Production support of SSIS jobs, SSAS cube & Monitor jobs.

Executive Reports: WW and Regional TAC SR Backlog By Age and Status, TAC SR by Division, TAC SR by Customer Region, Customer Care SR Summary by Division, Technical Support SRs Opened World Wide, World Wide Backlog Technical Support SRs, Technical Support SRs Backlog By Customer Region, Customer Care SR Backlog By CSR Region etc.

Confidential,

Responsibilities:

• Find/generate executive level support for the data warehouse initiative
• Define key business drivers for the data warehouse initiative
• Deliver a project scope that directly supports the key business drivers
• Define the overall data warehouse architecture
• Define technical requirements, technical and data architectures for the data warehouse
• Design and develop the ETL process, including data quality and testing
• Design and develop the information access and delivery effort for the data warehouse
• Define and implement security requirements for the data warehouse
• Define meta-data standards for the data warehouse
• Define production release requirements

Senior Developer,

Responsibilities:

• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Developed the database schema design using the Entity-Relationship model as per user requirements.
• Conformed the database model to the rules of referential integrity and Normalization (3NF) in order to maintain its consistency.
• In-depth understanding of processes involving data modeling and building data marts.
• Participated in the development and maintenance of a Date Warehouse / Data Mart Routine Load Schedule.
• Performed production support duties on a 24/7 basis.
• Involved in business requirements gathering to enable Data Integration across all business groups.
• Created executive reports using SSRS and build SSAS cubes for management.
• Responsible for coordinating development and testing efforts with offshore team members.
• Worked with heterogeneous sources including relational sources and flat files
• ouse and then to Essabase System.
• The jobs are invoked using Kornshell jobs and the loader program was written using Visual Basic. The daily verification excel sheet verifies the booking, billing, backlog daily basis between JD Edward and Data Warehouse.
• Any out of balance issues requires analyzing and immediately fixing the issues.

Project: Migration of Forecast application /Production Support of Forecast application