PROFESSIONAL PROFILE:

• 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 corporate - 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 corporate 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

Data Warehouse Developer / Team Lead

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.
• Monitoring, Investigating and fixing batch jobs.
• Created executive reports using SSRS and build SSAS cubes for management.
• Involved in the fixing of the bugs and code changes and enhancements through client requests.
• Technical Support to the Team and as well as Client.
• Tuning of Jobs to improve the performance.
• User testing and UAT sign off
• Leading the team for assigning the work.
• Involve in Coordinating between Client and development.
• Production support of SSIS jobs, SSAS cube & Monitor jobs.

Confidential

Data warehouse developer / Team Lead

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

Confidential

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
• Used complex SQL to query the database and was involved in SQL optimization of existing queries.
• Migrating SQL Server 2000 DTS packages to SSIS packages for uploading various formats of files and data from the legacy databases and SQL Server 2000 to MS SQL Server 2005 Data warehouse using SQL Server Integration Services (SSIS).
• Used DTS migration wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Created trace in SQL profiler and used database engine tuning advisor for performance tuning on stored procedures and Scripts.
• Created database maintenance plan for the performance of SQL server.
• Analyzed old reports designed in crystal reports and transform those reports into SSRS report with proper mapping and error handing.

Confidential

Data Warehouse developer

Responsibilities:

• Analyze daily basis any load failures and any data load failures in Booking, Billing, Backlog, Customer, Product, Shipment details to the Data Warehouse 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.

Confidential

Data Warehouse developer

Responsibilities:

• Support the Forecast Application.
• Migration of Forecast application from Windows 95 environment to windows 2000 environment.
• This project required to study the system and plan to move the ASP 3.0 developed application from windows 95 environment and IIS 4.0 to windows 2000 environment and IIS 6.0 and rewriting the reports by creating stored procedures and showing in excel.

Confidential

Visual Basic Developer

Responsibilities:

• Citation Laboratory system was developed on MS-DOS platform PL1 being the language and BETRIEVE as the Database.
• This Project involves migration of C-LAB system from its Character based screen to more sophisticated Graphical User Interface.
• As a GUI Developer, designed and developed GUI VB forms for different modules.

Environment: S/W- Visual Basic 5.0, O/S - Windows 95