| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
PHONE NUMBER AVAILABLE(Mobile) Email:EMAIL AVAILABLESUMMARYExtensive career Experience of More than 16 years in Software developmentand 12 years in Data Warehousing and Decision support Systems and hasWide Experience in implementing Data Warehousing solutions to largecorporate clients and has professional experience working in variousindustries such as Retail, Manufacturing, Pharmaceuticals, Finance andGovernment . > Strong Consulting experience in Implementing Full Life cycle Data Warehousing Projects. > Skilled in defining and implementing the various components of a data warehouse such as Operational source systems, Data staging, Data presentation and Data access tools. > Strong in Dimensional modeling techniques. > Strong in designing Star Schemas and snow Flake Schemas. > Skilled in Converting the Business Logic into Technical Specifications. > Over 12 years of experience with ETL tool Data Stage PHONE NUMBER AVAILABLE.0/4.0. > Over 12 years of experience with Business Objects 4.1/4.0/X1 R3/6.5/5.1/4.0, Web Intelligence. > Over 12 years of Hands-on experience in designing, tuning, and leveraging large data warehouses. > Over 14 years of experience in implementing Oracle database applications. > Over 3 years of experience in Data Modeling. > Over 10 years of experience in AIX environment. > Expertise in deploying OLAP tools, Materialized Views, and partitioning techniques for highly responsive Decision Support Systems. > Over 4 years of experience with ETL tools such as Informatica (Power Mart/Power Center). > Over 3 Years' Experience working as an Independent Verification and Validation (IV&V) Consultant.EDUCATIONMBA, Information Systems and MarketingBachelor of Engineering, ElectronicsSKILLS > DW Development - 14 years > DW Architecture - 12 years > Business Intelligence/Reporting -14 years > SAP - 2 years > Business Objects -14 yearsProfessional Experience:BCBS, Richardson, TX Nov2014-TilldateSenior Data stage / Info Sphere ConsultantBlue Cross and Blue Shield known for health care coverage. It has beenaround for more than 80 years, and the cross and shield has come torepresent the most experienced health care coverage organization in thestate and the nation. The Data Integration Hub (DMIH) project isresponsible for the processing of changed data transactions (generated frominternal and external source systems of record) into conformed andstandardized data ready for consumption by the enterprise. The DMIH willemploy an Integration Data Store and Enterprise Metadata to accomplish thistask. . Involved in meetings with business analysts to gather and understand the business requirements and process flow details in order to plan the ETL extraction and loading. . Extracted data using different strategies from the various native SQL against relational databases like DB2,Teradata and flat files for multiple projects involved in. . Enhanced and developed data stage jobs for data load into Fact and Dimension Tables using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Sequential file, Dataset, Funnel, Remove Duplicates, Copy, Modify, Filter, Surrogate Key . . Imported healthcare data from various transactional data sources residing on DB2, Teradata ,flat files and performed Null value handling, data Cleansing using null handling functions and UNIX. . Developed complex jobs and made sure that each record in all processed files has at least one ETL action indicator in its corresponding ETL audit table identifying if the record was an insert, update, no change, or delete followed by loading into oracle Database and flat files. . Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs. . Involved in writing UNIX shell scripts for automation, job run, file processing, initial load, batch loads, cleanup, job scheduling, and reports Linux/UNIX environment. . Created Audit jobs and generated Reconciliation reports balancing the Source and target record counts using DS Job Report Functions and DS job commands by reading job Start time, End time, Source records count, Target records count, Reject records count and no of warning messages generated in the DataStage director log. . Extensively worked on error handling, data Cleansing and performing lookups for faster access of data. . Used lookup stage with reference to RDBMS tables for insert/update strategy and updating of slowly changing dimensions. . Involved in Unit testing, Integration testing, UAT by creating test cases, test plans and helping Data stage administrator in deployment of code across Dev, Test and Prod Repositories.Environment: IBM Info Sphere DataStage 8.5 (Designer, Director,Administrator, Parallel Extender), Db2, Teradata 13, Sequential files,Zena, UNIXOffice Of Information Technology, State Of New Jersey, Trenton, NJ Sep2003 - October 2014Title: Senior Systems Integrator /Data warehouse Architect (ETL andBI)//IV&V Consultant . Liaise with business subject matter experts in analysing business requirements (Productivity related - KPIs), understand the various data sources. . Architect the productivity data mart. Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10g. . Conducted Verification Activities for the Clients. . Used Verification techniques such as Code reviews, Inspections and Process walk Trough's. . Used Validations techniques such as Unit testing, Functional Testing and User Acceptance testing, . Develop strategies for use in high volume, high performance heterogeneous environment. . Map source data elements from various systems like -eCATS,NJAWS(Treasury),BMS,Transparency and develop, test, and support extraction, transformation and load processes. . Analyzed source data and Applied business rules to the data in the raw data mart and load it to the reporting data repository. Defines and captures metadata and rules associated with ETL processes in Datastage. . Design and develop the technical/functional specification for ETL development and implement using Datastage. Analyze dependencies for Sequences for various ETL processes, handle exception, and maintain logs. . Manage artifacts - versions, including software code, documents, design models, and even the directory structure itself. . Designed specifications for reports. . Documented all Meta data dictionary. Involved in Full life cycle design and development of Business Objects reporting Applications. . Involved in designing data marts from data warehouse and generated reports using Business Objects. . Designed reports in outline mode for different hierarchies. . Designed and maintained Complex BO universes for report development. . Involved in testing new feature in BO XIR3.Environment: Data Stage 9.1/8.7/8.1/7.5 (Manager, Designer, Director,Administrator), SAP Business Objects 4.1/4.0/ XIR3/6.5, ER/Studio, Oracle9i/10g, AIX 5.2KOMATSU America Inc, Chicago, IL DEC 2002-SEP2003Title: Project Lead (Data warehouse Consultant) . Involved in system analysis and design of the Data warehouse. . Responsible for designing Data warehouse schemas using Erwin. . Developed Functional (Business terms) and Technical Design documents. . Involved in developing Logical and Physical Data Models. . Responsible for Formulating the DW process to load from sources to Target tables. . Involved in Installation of Data stage 6.0 and setting of ODBC drivers. . Implemented security for data stage projects and groups. . Designed data stage jobs logic flow from Various Sources to ORACLE Data warehouse. . Developed Data Stage jobs where in using data stage, data from different sources formatted, Cleaned, summarized, aggregated and transform into data warehouse. . Developed database triggers for data validations. . Responsible for integrating the data warehouse on both Windows and Unix platforms. . Designed, build, and maintained Business Objects universes. . Responsible for fitting Business Objects into the Information Architecture of the company as well as supporting business users and developing new and maintaining existing Universes. . Design and develop extensive Business Objects reports, including complex reports using multiple queries, combination chart and tables, Will set up Business Objects Universe for each reporting group Assist in establishing a Business Objects environment. . Interaction with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering the solution.Environment: Business Objects 6.0 Enterprise (Designer, Reporter, Infoview, Supervisor, Broadcast Agent and BO Web Intelligence),Data Stage 6.0Oracle 9i, Windows NT Advanced Server, UNIX (Solaris, AIX), , SQL Server2000,SAP R3, Windows 2000.BP-Amoco, Warrenville, IL Oct 2002-Nov2002Title: Team Lead (Data warehouse consultant) . Involved in the Design of the BIE Data warehouse. . Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage. . Mapping Data Items from Source Systems to the Target System. . Interviewed users to collect requirements, analyzed them and transformed them into technical specifications. . Generated various reports as per the client's requirements . Used Business Objects 5.1.2 for developing reports . Responsible for Creation of the Universe with Classes, Objects and Condition objects. . Resolved loops in universes using Aliases and Contexts. . Set up Aggregate Awareness to enhance the performance of SQL transactions. . Developed Hierarchies to support drill down reports . Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc. . Responsible for creating various Users and implementing Securities depending upon the operational basis using BO Supervisor. . Involved with documentation of the code, organizing production and deployment. . Assisted in creating technical documentation and user manuals. . Extensively involved with end user training in Business Objects Reports.Environment: Business Objects 5.1/5.0 (Designer, Reporter, Info view,Supervisor, Broadcast Agent and BO Web Intelligence), Data Stage4.0,PL/SQL, Windows NT Server 4.0, UNIX (Solaris, AIX), ORACLE 8i, SQl Server2000,SAP R3, Windows 2000.Bearing Point (Formerly KPMG Consulting), NY July 2002-Oct 2002Client: Pfizer Inc. (SEE Group)Title: MIS consultant . Involved in the design of the data mart . Interviewed users to collect requirements, analyzed them and transformed them into technical specifications. . Responsible for design and development of reporting system using Business Objects 5.1.2 as well as training end-users. . Responsible for Creation of the Universe with Classes, Objects and Condition objects. . Resolved loops in universes using Aliases and Contexts. . Set up Aggregate Awareness to enhance the performance of SQL transactions. . Developed Hierarchies to support drill down reports . Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc. . Tuned the reports for better performance using SQL. . Involved with documentation of the code, organizing production and deployment. . Assisted in creating technical documentation and user manuals. . Extensively involved with end user training in Business Objects Reports.Environment: Business Objects 5.1/5.0 (Designer, Reporter, Info view,Supervisor, Broadcast Agent and BO Web Intelligence), Informatica 5.1,PL/SQL, Windows NT Server 4.0, UNIX (Solaris, AIX), ORACLE 8i, Windows2000.Employer: Global Cynex INC May 98 -July 2002 Responsibilities
. Involved in system analysis and design of the Data warehouse. . Responsible for designing Data warehouse schemas using Erwin. . Developed Functional (Business terms) and Technical Design documents. . Involved in developing Logical and Physical Data Models. . Responsible for testing and data quality the data and conforming it to the business rules before loading to the Data Warehouse. . Involved in connecting to Oracle, Sybase, db2 databases and other flat files using ODBC. . Developed data base triggers for data validations. . Written stored procedures for complex calculations. . Created Partitions and indexes on database tables for faster execution of queries and involved in database performance issues. . Developed complex transformations like aggregator, expression and filters etc. . Worked extensively with lookup and Router transformations. . Created folders and users with repository manager. . Ran batches and sessions with Informatica server manager. . Developed mappings, transformations, sessions and batches using Informatica power center 5.1. . Provide technical support for data warehouse . Deploy application to end-users. . Responsible for integrating the data warehouse on both Windows and Unix platforms. . Designed, build, and maintained Business Objects universes. . Responsible for fitting Business Objects into the Information Architecture of the company as well as supporting business users and developing new and maintaining existing Universes. . Design and develop extensive Business Objects reports, including complex reports using multiple queries, combination chart and tables, Will set up Business Objects Universe for each reporting group Assist in establishing a Business Objects environment. . Interaction with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering the solution.Environment: Informatica power center 5.1,Erwin4.0, Oracle 8i,Terradata, Sybase, DB2, MS-access, SQL Server, HP Unix, Windows NT4.0/2000, Business Objects 5.1.1, Web Intelligence 2.7, IIS, ASP, MS FrontPage, VB Script, HTMLInterface technology Group Mar'96 to May'98This Project was done as part of my CourseworkResponsibilities: . Designing of Forms. . Coding & testing. . Documentation and Maintaining Versions.Environment: Visual Basic 5.0, oracle 7.1. |
