SUMMARY:

• 12+ Years of total IT experience in managing/leading data warehousing projects, requirement gathering, Data Architecture, Data Modeling, Data Analysis, Data Profiling, Data Lineage, technical analysis, design, development & implementation of business applications
• Experienced data architect on relational and dimensional model design and methodology from multiple perspectives and hands - on experience in designing extraction, transformation, and load (ETL) techniques on multiple database platforms and operating systems.
• Solution Architect, end to end solution architecture for OLTP database, data warehouse/ data marts and business Intelligence/ analytics projects
• Experience on database modelling tools like Erwin
• Good knowledge in Business Intelligence (BI) domain, Data Warehousing, using MS SQL Server 2012/2008, MS SQL Server Integration Services (SSIS), DataStage, Hyperion Interactive Reporting
• Worked throughout the SDLC and actively involved in development of project scope; collection and documentation of business requirements, preparation of related process documentation, source to target mapping, preparation of change control documentation, and coordination of user acceptance testing
• Worked as a liaison between the business and IT data warehousing team. Good at performing Gap Analysis between “As Is” system and “To Be” system.
• Analysis skills to understand the needs of business users and stakeholders and transform those into functional/technical requirements.
• Knowledge of processes followed in Data Migration project, End to End Data Warehouse Development Project and Data Warehouse Enhancement Project. Worked on Informatica data quality 8.5 tool
• Worked on databases like SQL Server, DB2, Oracle
• Worked on performance tuning for stored procedure and SQL/ PL SQL on databases like SQL Server, DB2, Oracle, by adding non clustered index, by monitoring plan of query, by replacing high cost commands with low cost commands
• Worked with teams to examine business problems by accurately analyzing the needs of clients and helping them achieve improved quality and value for their customers
• Successful as a team player to work in conjunction with other testers, developers and other team members in the maintenance of quality standards in projects

TECHNICAL SKILLS:

Operating System: Windows 98/XP/2000/7, UNIX, LINUX

Databases & Tools: Oracle 8i, SQL Server 2012/2008,DB2, SSIS, SSAS, Datastage 7.5.2, 8.1, 9.1, Hyperion Interactive Reporting tool, Informatica Data Quality tool, MS Visio, RequisitePro, Rational Rose,Erwin

Other Utilities: MS Office Suite, Quality Center, Rational ClearQuest, StarTeam, VSS,Tidal

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Project Lead/ Data Analyst/ Data Architect

Responsibilities:

• Performed source system analysis and data profiling on source system. Performed data lineage to create source and target mapping.
• Worked throughout the SDLC and actively involved in development of project scope; collection and documentation of business requirements, preparation of related process documentation, source to target mapping.
• Gathered functional, technical requirements and prepared Data Mapping documents, Design Specifications and Test case documents
• Worked on oracle database, PL SQL and SQL server database, Datastage 11.5
• Conducted Business Requirement Document walkthrough session with Development team and QA team

Confidential, Hoboken NJ

Tech Lead/ Data Analyst/ Data Architect

Responsibilities:

• Prepared process flowcharts for documenting the requirement specifications.
• Performed source system and data profiling on source system. Performed data lineage to create source and target mapping.
• Conducted session with designers, developers and testers to discuss specific requirements and also attended defect triage meetings
• Worked on oracle database, PL SQL and SQL server database, IDQ Informatica data quality and Datastage
• Conducted UAT for verifying continuous functioning of day today activities of business

Confidential

Project Lead/Data Analyst/ Data Architect

Responsibilities:

• Created Plan to Automate existing process
• Researched and analyzed the various steps in the claims processing lifecycle in MNLR database
• Responsible for interviewing business users, document technical requirements, provide leadership in creating the overall system architecture, identify the various elements and classify their dependencies.
• Worked on Datastage ETL tool, SQL Server database and oracle database PL SQL
• Design and Develop the data warehouse data model load strategy
• Design the data mart to support the reporting requirements
• Conducted Business Requirement Document walkthrough session with Development team and QA team
• Conducted UAT for verifying continuous functioning of day today activities of business

Confidential

Project Lead/Data Architect

Responsibilities:

• Consulted the SMEs and Third party vendor to understand the manual existing process to create reports for management.
• Created dimensional model, identified existing dimensions and created new dimensions as per requirement. Worked on Erwin.
• Involved in source data analysis, create data mapping document, data architecture, data model
• Worked on SSIS ETL tool, SQL Server database and oracle database PL SQL
• Developed SSIS ETL to pull data from various sources like Oracle
• Conducted walkthrough session with offshore team for Design Document

Confidential, Philadelphia, PA

Tech Lead/Data Architect

Responsibilities:

• Worked on Consumer Data migration project from SQL server 2008 to SQL server 2012
• Developed stored procedures and SSIS packages to pull data from various sources to SQL Server
• Developed jobs in Datastage ETL tool 7.5.2 and 9.1
• Worked on performance tuning for stored procedure on DB2 database by keeping statistics up to date, logs and the temp database on separate devices from the data.
• Prepared process flowcharts for documenting the requirement specifications. Involved in creation of Conceptual data model
• Worked on the high level design and met with the modeler to have the TD objects modeled. Prepared the design documents for the project that includes mapping documents, Data Lineage-Visio documents. Worked on Erwin tool and IDQ Informatica Data Quality
• Conducted session with designers, developers and testers to discuss specific requirements and also attended defect triage meetings
• Created the user requirement specifications and helped convert them to functional requirements, and assisted the developers with system requirement specifications
• Also, worked as Tech Lead role in Group Reporting Project. Tech Lead role comprises the list of responsibilities such as Requirement Analysis, Application design Effort Estimation, Application coding, Work allocation, Traceability matrix preparation Bug tracking, Bug fixing, Onsite offshore coordination
• Used array of languages such as SQL, PL/SQL, UNIX and Stored Procedures depending on the specific requirement of the project

Confidential, San Antonio, Texas

Responsibilities:

• Prepared process flowcharts for documenting the requirement specifications.
• Involved in Coordinating with client and offshore team and worked as Datastage ETL Lead
• Developed User specification documents. Also, Gathered business requirements by driving user-group meetings and working with various global, cross-functional and virtual teams
• Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted
• Promoted used of Stored procedure in project to improve the performance by reducing network traffic, providing better security to your data, code reuse, Stored procedure execution plans can be reused
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams
• Performed data analysis by using SQL queries using SQL server database tool
• Developed Jobs Using Datastage PX 8.1, Schedule, these jobs will be interacting with Oracle for Extracting data using query
• Performance turning Oracle PL SQL queries for Extracting data using query
• Involved in development and review of deliverables which includes Datastage jobs

Confidential, Peoria, IL

Tech Lead/Data Architect

Responsibilities:

• Managed end to end data warehousing development project and involved in all phases of Software Development Life Cycle (SDLC)
• Worked as liaison with the business users to understand business and data requirements.
• Involved in Data profiling to understand the current data set and analyze those reports to identify existing DQ issues, via workshops with SME and also Involved in GAP analysis and mapping
• Analysis skills to understand the needs of business users and stakeholders and transform those into functional/technical requirements
• Prepared business flowcharts, USE case diagrams and corresponding activity diagrams to depict the workflows to be incorporated into the development of business process
• Developed Functional specifications and technical specification documents
• Developed Jobs Using Datastage PX 8.1, Schedule these jobs using Tidal scheduling tool, these jobs will be interacting with Oracle for Extracting data using query
• Provided support on understanding requirement to the End to End Integration / Regression Test Team

Confidential, Boston, MA

Tech Lead/Data Architect

Responsibilities:

• Involved in creating Functional Requirement Specification (FRS) document and User Requirement Specification (URS) document for system application development
• Involved in supporting various teams such as Development, QA and Technical Support teams and worked as ETL Lead
• Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancement
• Performance turning Oracle queries for Extracting data using query
• Worked as a Datastage administrator which included activities like Install/upgrade server, client or patches, Reporting (daily, weekly, and monthly) on health and performance of the ETL environment and jobs, analyzed existing Infrastructure and DataStage jobs, ensuring best practices are being followed, and recommending short term and long term
• Developed SAP LSMW (using Recording, Standard Program, and BAPI) as per Functional Specification Provided and involved in Coordination with client and offshore team
• Also, involved in Datastage project creation, user roles, configuring data sources, maintaining DS servers, and engine and domain servers. He was also involved in development and review of deliverables which includes Datastage jobs.
• Developed and managed one Confidential module
• Developed Jobs Using Datastage PX 8.1, Schedule these jobs using Tidal scheduling tool, these jobs will be interacting with Oracle for Extracting data
• Developed the plans/jobs Using Informatica Data Quality 8.5.0
• Involved in development and review of deliverables which included Informatica Data Quality jobs
• Involved in documenting the plans/jobs created in Informatica Data Quality 8.5.0 and also documenting the processes followed in the projects