SUMMARY

• An articulate software professional with 8 years of experience in Life Science domain and across System Analysis, Integration analysis Design, Maintenance, Testing & support. Currently spearheading with Confidential Pasteur AMERICA as Senior Techno - Functional Architect.
• Expertise includes Business development, building strong teams & strategic thinking on technology led business transformation and future of work.
• Worked as a Business Analyst/Business System Analyst using the iterative Software Development Lifecycle (SDLC) with extensive experience in the field of business analysis and process re-engineering.
• Have led several Requests for Proposals (RFP’s) and shown expertise in building prototypes.
• Experienced in gathering business requirements for Data warehousing in a Service Oriented Architecture (SOA).
• Have experience in various business domains and have good understanding of business process, KPI’s and reports used by different departments in multiple domains..
• Driving the project by keeping track of the open issues, coordinating efforts within team and ensuring that the project is delivered within its stipulated time frame.
• Efficient in writing Business requirements document, Use-case Specifications, Functional Specifications, customer requirement Documents and Workflows.
• Strong analytical and problem solving skills for understanding the functional requirements and design of the business application.
• Performing data analysis by identifying the different data sources, creating logical data models and establishing relationship between entities.
• Experience in the documentation of specifications, creating step-by step technical and user manuals with illustrations, designing and implementing new processes and technology.
• Excellent communication skills, leadership and management abilities and an effective team player.
• Worked closely on generating process Workflows & Design flows as part of the technical design.
• Demonstrated ability to remain flexible, unfazed and on-track in an environment of tight deadlines and high expectations.
• Efficient in translating Business Requirements into Functional and Non-Functional Requirements.
• Strong Subject Matter Expertise in sectors like Life Sciences.
• Have a very good hands-on experience in data analysis, working with external vendors like IMS for DDD and CDC related weekly & monthly data.
• Have worked with major pharmaceutical companies like Confidential, Confidential, and Health insurance companies Confidential and have handled and supported large data warehouse for Business Intelligence and Analytics area.
• Have good exposure and knowledge to data related to Vaccine, Sunshine-Act, Pharmacovigilance and Specialty Pharma data.
• Proficient in working on Informatica 9x, Control-M 7.2, PRO*C, Oracle 9i, 11g client, plsql, Unix Shell Scripting plus well versed in estimating, designing, development and testing financial application. Possess basic knowledge on Alteryx, QlikSense, Tableau, Qlikview 10, Business Objects XI R2 & Cognos ReportNet.
• Core Competencies:

TECHNICAL SKILLS

Technology(ETL Tool): Informatica Power Center 8.5,8.6 and 9.1,Informatica Cloud,SSIS,SSAS,SSRS

Technology(Reprting Tool): MicroStrategy 10.4/10.1/9. x/ (Desktop/ Developer, Architect, Report Services, Web, Mobile, Administrator, Intelligence Server, Enterprise Manager, Object Manager, Integrity Manager, Command Manager, Distribution Services, Narrowcast and Tools)

Database: Oracle9i/10g, SQL ad PL-SQL, Teradata, Sql Server 2008

Business Domain: Life Science, Healthcare and Insurance

S/W Packages: TOAD, SQL Developer, Teradata sql assistant.

Special Software: Visio, MS-Office

Data Modeling: Strong knowledge of Dimensional Modeling

PROFESSIONAL EXPERIENCE

Confidential

ETL developer and Solution designer

Responsibilities:

• Gather, validate and write business and technology requirements and functional specifications document
• Develop/Create statement of work, project objectives & metrics, business requirements, use cases, storyboards, functional specifications, systems & end-user documentation
• Understand existing business processes (Ecosystem discovery and integration roadmap) and complete required documentation. Craft business process basis requirements
• Responsible for the overall configuration, design, and functionality of the Salesforce / Veeva Vault functions;
• Build and maintain mobile solutions leveraging Salesforce.com as a platform;
• Configure and maintain the functional objects of Salesforce.com;
• Create and manage workflow rules, data validations, triggers, and object customizations;
• Manage operational requests and assist in the escalated triage of support issues, working with diverse user groups;
• Assist in gathering requirements to continuously improve the CRM platform;
• Assist in the evaluation of new Veeva & Salesforce.com functionality and App Exchange tools for feasibility and impact to the business;
• Create and maintain system interface diagrams, functional designs, and technical specifications;
• Support the Veeva BPO in the development of full process SOPs and training when applicable;
• Create process for loading Employees,Territories, Divisions, Regions, Sales forces,Rep territory assignments,Customer Alignment,Customer deciles, Vaxserve Business Units, Customer call Frequency, ATI from Veeva system to ODS using informatica cloud.
• Design, setup and maintain Salesforce standard objects, custom objects and junction objects, while also structuring user roles, security profiles and workflow rules.
• Ensure data integrity through the appropriate use of de-duping, loading and exporting tools, for bulk of data using Data Loader, Admin Garage and Lexi Loader.
• Create and update users, reports and dashboards to track pipeline/stages for management visibility, while integrating Appex (applications) to Salesforce accounts such as Conga Merge and Outlook.
• Perform user & administration training sessions for clients to utilize Salesforce and respective programs.

Confidential

ETL developer and Solution designer

Responsibilities:

• Gather, validate and write business and technology requirements and functional specifications document
• Develop/Create statement of work, project objectives & metrics, business requirements, use cases, storyboards, functional specifications, systems & end-user documentation
• Co-ordinate with project team on daily basis to track the activities and align on upcoming deliverables
• Understand existing business processes and complete required documentation. Craft business process basis requirements
• Perform data analysis to compare datasets from various technology databases
• Work with the technical teams to ensure that business requirements are understood so that plan, build and run can effectively deliver
• Active participation in Application design, development and Unit testing
• Task delegation to offshore and keeping track of progress
• Provide Business Intelligence Solutions using Micro Strategy Reporting Suite which Includes Desktop, Web, Intelligence server, Architect, Reporting services, Narrowcast Server, Administrator, Enterprise Manager, Object Manager, Integrity Manager, Operations Manager & Tools.
• Create and modify Micro Strategy Schema objects (such as Attributes, Facts, Hierarchies, Transformations etc.), Application Objects (such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects (such as project, users, User Groups, security filter etc.) using Micro strategy desktop
• Created many Visual insights like Health Systems Management, Buying Group Management and trained Business users on how to Blend External Data and integrate it with the existing schema.
• Created complex metrics like Market Share by Different Product, Region and Customer Segment, Comp%, Growth, Fair Share, Profit Ratio, Decile, Raking of customer’s at different Levels, Call Frequency, Win and loss calculations in Tender Management, Created multiple Gates or Buckets, Forecast for Flu Demand planning.
• Create FedEx distribution and delivery along with daily sales report.
• Create loss/gain auto report based on the order dose changed by customers on a daily basis.
• Extensively worked in both Ad-hoc and Standard Reporting Environments and involved in creating reports scalable to large volumes of data.
• Participate in periodic status report and inform stakeholders about the risks and issues
• Understanding the business needs and suggesting a ETL solution
• Development of specification documents based on Business requirements
• Conducted meetings and checkpoint calls with offshore team / Clients
• ETL Analyst, which include creating ETL objects as per requirement
• Analysis.
• Coding (involves policy rule coding, sequence flow, status flow, and dictionary entries
• Review of Offshore artifacts
• SIT,UAT support activity
• Data analysis/Modification as per user request
• Review the code and deliverables
• Resolving Data inconsistency issues
• Review the code and deliverables
• Support for system integration testing and analyzing the data issues
• Code deployment activities
• Post Production activities like warranty support, KT Plan and transition to support team

Confidential

Module leader

Responsibilities:

• Gather, validate and write business and technology requirements and functional specifications document
• Work with the technical teams to ensure that business requirements are understood so that plan, build and run can effectively deliver
• Develop the necessary documentation for IT solutions projects working closely with Project Managers - e.g. statement of work, project objectives & metrics, business requirements, use cases, storyboards, functional specifications, systems & end-user documentation
• Ability to articulate complex technical problems and solutions to a wide business audience
• Support the vendor selection process with clear requirements for RFI/RFP’s
• Integrate, develop and support operations of MDM/Data Warehousing / BI systems
• Understand existing business processes and complete required documentation. Craft business process basis requirements
• Perform data analysis to compare datasets from various technology databases
• Examine data discrepancies in the customer and account master structures
• Prepare data architecture, user and functional requirements, and design documentation
• Adhere to enterprise-wide BI governance policies and procedures
• Coding (involves policy rule coding, sequence flow, status flow, and dictionary entries).
• Review the code and deliverables

Confidential

Team Member(TM)

Responsibilities:

• Prepared Business Requirements document according to requirement related to Amazon Sales and Channels reports
• Facilitating design walkthrough with business partners and developers on ground.
• Pare pared Harmony and Multi-Channel interactions which will provide reporting for sales representatives and local management as well as country, area, regional and global views
• Prepare weekly Dashboard for higher management for reporting KPIs.
• Manage incidents and service request using JIRA Dashboards and project tracking.
• Preparing Flu Vaccines related Dashboards for client’s management team.
• Responsible for analysis, design, development, testing and implementation of enterprise data warehouse and business processes.
• Preparing estimates for the application on-boarding/change requests/bug fix.
• Provide centralized governance, technical artifacts, and platforms and best practices.
• Facilitate weekly status calls involving business, development, and QA teams.
• Consult the business and technical team on al technical and functional issues and help design effective solutions.
• Documentation as per the AZ-ISPDM standards
• Coding (Informatica and Oracle Pl/SQL): In mapping we have used dynamic lookups and persistent cache as per requirement.
• Created load control mechanism for one of the subject area Territory Services: Load control table will give the status of job as well as load completion information of Territory Services files. In this mechanism we have created control tables as well as Procedure.
• Unit Testing. (UTC creation and execution)
• Review the code and deliverables
• Support for system integration testing and analyzing the data issues
• Code deployment activities
• Post Production activities like warranty support, KT Plan and transition to support team
• Team Management activities

Confidential

Module lead(ETL),Defect Prevention, Developer

Responsibilities:

• Coding of Informatica mappings using the mapplet and various transformations.
• Coding of Sessions, workflows and connection strings for Loader as well as relational connectionsDesign of mapping for loading oracle tables through Teradata as source, to provide the data to a Provider Online Interactive tool.
• Coding of complex sessions to call different UNIX scripts.
• Coding of the UNIX scripts with Teradata BTEQ queries.
• Error handling and code flow using BTEQ scripts designed for two modules.
• Peer review of Informatica mappings and BTEQ scripts.
• Testing of the scripts end to end and data verification from Informatica to Data Mart tables.
• Designing of scoring engine flow from stage to data mart table was done with intermediate call to Informatica and BTEQ scripts.

Confidential

Team Member

Responsibilities:

• Prepared Business Requirements and Functional Requirements documents according to the business requirements.
• Performed Business Impact Analysis, feasibility analysis of proposed projects, processes and solutions.
• Enhance/Modify/Implement new changes as and when requested by business team throughout the project life cycle.
• Preparing estimates for the change requests.
• Provide centralized governance, technical artifacts, and platforms and best practices.
• Consult the business and technical team on al technical and functional issues and help design effective solutions
• Coding of Sessions, workflows and connection strings for Loader as well as relational connections
• Design of mapping for loading oracle tables through Teradata as source, to provide the data to a Provider Online Interactive tool.
• Coding of complex sessions to call different UNIX scripts.
• Coding of the UNIX scripts with Teradata BTEQ queries.
• Error handling and code flow using BTEQ scripts designed for two modules.
• Peer review of Informatica mappings and BTEQ scripts.
• Testing of the scripts end to end and data verification from Informatica to Data Mart tables.