Career Pr cis

To pursue a proficient, dynamic and challenging career in IT Industry and to keep up with the latest trends and technologies, seeking an environment where my experience and knowledge can be shared and also where I can enhance my technical, analytical and personal traits.

Professional Summary

• Around 6 years as a Business Analyst for Data Warehouse and Data Mart Applications
• Functional and Non-Functional Requirements wrote for Banking, Retail, HR and LIMS Projects
• Published epic and story cards as per the requirement traceability matrix
• Wrote the Technical Specifications
• Analyzed scope-creeps, initiated and worked on Change Requests CRs , tracked and closed after its deployed
• Acted as liaison between business units and IT development teams on issues
• Worked on SOCS compliance projects and with ABCs Audit, Balance Controls .
• Worked closely in various Project Management Life Cycle SDLC, Agile, Scrum Methodologies
• Prepared Weekly Status Reports, any issues or concerns depending on severity of project status updated in SharePoint logs, thru emails
• Build the UML Use Case, Sequence, State, and Process Flows using MS Visio and Rational Rose Tools
• Reviewed Normalized / De-Normalized Data Models to support Transactional and Star/Snowflake Schemas
• Standardized Data Elements for Master golden record , Reference and Meta Data Attributes
• Worked with Procedural and Component based Data Integration solutions
• Experience in Informatica Power Center, Workflows, Workflow Monitors, and Batch Job design and scheduler
• Extensive knowledge in Data stage
• Well versed in PLSQL, SQL Loader, T-SQL, Export/Import, External Tables, and Bulk Load Process
• Wrote SQL Scripts for Aggregate and Analytical Functions and performance tuning using Explain plain
• Created and Validated various life cycle Test Plans and Test Scripts in Unit, SIT, UAT environments.
• Co-ordinate and liaised off shore team
• Supported Project teams/EIT teams Architects,Development,QAT
• Created and validated various test plans and wrote test scripts to support UAT
• Organized Development sessions for Indian Offshore and New York Onsite Teams
• Excellent communication skills and ability to work effectively and efficiently in teams and individually

Technical Skills

• Oracle 11g/10g/9i, SQL, PL/SQL, SQL Loader, T-SQL, SQL Server 2005/2008, Teradata V2R12/V2R6
• Informatica Power Center 9.0.1/8.6.1/8.1.1, Infosphere Data Stage
• Toad 10.5/10.1/9.1, Erwin Data Modeler, Sybase Power Designer
• Windows 2003/2008/XP, UNIX, HP Quality Center, PUTTY, Secure CRT 4.0
• Word, Excel, PowerPoint, Visio, Access, Project and Rational Rose Tools

Professional Experience

Confidential

• Worked with Clinical Pathologists and Lab Technicians at various phases to gather functional and reporting requirements
• Wrote the epic and score cards using agile methodologies to capture around 30 clinical decision reporting functionalities
• Consolidated end to end business requirements, processes, use cases, and created traceability matrix.
• Data Points captured for Patient, Physicians, Hospitals, Labs, ICD, CPT, Microscopic Images, and Genetic Lookup Codes.
• Designed conceptual and data process flow diagrams, decision flows, decision tables to capture the business rules.
• Analyzed requirements, created data element list have done system analysis and gap analysis.
• Reviewed Business requirements with the team, explained data elements and Audit/Balance/Control requirements, SLAs.
• Worked with Architects and other Analysts on the initial investigation. Involved in technical discussions to get a good understanding of the proposed solution and updated Business time-to-time on the requirement feasibilities upfront, to set a fair level of expectations.
• Wrote validation scripts for Reporting Data Mart using Star Schema Methodologies which supports around 20 dimensions and 12 facts.
• Wrote the User guide for Reporting Run Book which Pathologists and Clinical Lab Technicians are consuming
• Implemented Business Governance on Data Element Standardization for the Client data
• Extensive knowledge CDC collapsing logic and SCD Type1,Type2,Type3 and Type7 implementation logic
• Worked closely with Project Delivery Managers on deliverables, timelines and reported status in daily scrum and weekly team meetings
• Managed requirement scope, monitored notified project team on scope creeps and created Change Request documents CR
• Interacted with Database, Application and Reporting Developers to address open queries
• Validate data elements and end to end data flow
• Worked with cross functional teams Business, Application Product development teams, Architecture, Data modelers, DBA, Development, Quality Assurance QA , Security, and Release management teams
• Supported coordinated UAT between Business EIT teams
• Environment: SQL Server 2008, Excel Macros, Visio, Project Plan, Crystal report as Power User

Confidential

• Worked with Key Stakeholders to gather requirements and data requests from internal and external clients
• Design and develop the web analytics related data mart application to extract data from applications and external sources
• Finalized the core data items thru research, analysis, profiling, mining and discovery from the source systems
• Wrote SQL Queries, standardize the documents and business process
• Analyzed traffic analytics, product direct sales analytics and revenue analytics in order to identify profitability
• Perform market research and analyze various pre and post compiled data points from various web logs
• Wrote the Extract, Transform and Load Process requirement documents across multiple platforms for data mart app
• Strong knowledge performed in the concepts like CPC, CTR, LTV, CPM, RPM concepts
• Wrote relational database SQL joins as well as strong analytical and aggregated functions
• Ability to interpret all online data to proactively address issues and concerns that impact directly and indirectly
• Proven results to communicate complex quantitative analysis in clear, precise, and actionable manner
• Wrote the test scripts including but not limited to UAT, QA, Unit and Browser data verification to provide data integrity
• Provided inputs to leadership and served as liaison between the team and project managers at client environment
• Partnered with Product Manager, Technical Teams and Vendors to deliver on department goals in a cross functional areas
• Provided data visualization that clearly addresses relevant information to appropriate stakeholders.
• Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL, SQL Loader, PL/SQL, Toad for Oracle 10.5, Windows XP, MS Access, Excel

Confidential

• Involved in preparing Process Flow Diagram other UML Diagrams using MS Visio
• Gathered reporting data requirements from the cross-functional departments
• Analyzed existing system and studied new business requirements. Initiate the design development process. Acted as technical delivery manager, supporting the Project manager in activities like team coordination's, internal team meeting setup, status update to PM, rest of team, and leadership, appropriate level of escalations based on the severity of status, update of the project share point of the status, risks, assumptions, dependencies.
• Provided Business Data Requirements to the Data Architecture and Development Team
• Conducted JAD Sessions involving the user community to identify, analyze and formalize requirements and establish working relationships with business functions and solution delivery team to meet the individual needs of the business functions.
• Prepared technical specifications documents and supported core technical teams during data modeling and source to target mappings, and development.
• Developed Requirement Traceability Matrix RTM high level test scenarios, and tracked them thru the project lifecycle.
• Coordinated with Business teams during UAT sessions.

Environment: Oracle 10g, PL/SQL, SQL Loader, SQL Plus, Windows 2003, MS Office

Confidential

• Wrote the Data Warehouse Requirements from the existing operations systems
• Designed and Deployed star schema data model and deployed DDL script
• Wrote the SQL, PLSQL Procedures, Functions, Packages, and Triggers programs
• Data updates, inserts and soft deletes performed thru procedures
• Wrote the partition, index scripts to improve and manage the data patterns
• Created user access privileges and schema object permissions between the instances
• Maintained all the scripts to deploy into various environments using subversion

Environment: Oracle 9i, PL/SQL, SQL Loader, SQL Developer, Windows 2003, Microsoft Office Suite