SUMMARY

• Development / Delivery| Project Management | Planning & Analysis | IT Strategy & Execution | Team DevelopmentHighly analytical wif 16 years of IT and Project Implementation experience. Cross - functional Matrix Environment. Deep experience in implementation of scalable, efficient and complex distributed computing environments handling hundreds of terabytes of data from multiple sources.
• Expertise in technology products for Life Sciences, Insurance, Healthclare, Pharma, Telecom, Retail, Utilities and Clinical Trials. Performance driven professional known for delivering projects on time and wifin budget. Proactive and high achiever recognized as a strong team player wif keen eye for detail. Received awards and ovations for outstanding performance from various clients.

PROFESSIONAL EXPERIENCE

Confidential

Technical Project Manager

Responsibilities:

• Collaborated wif end users, project stakeholders and support partners to identify needs, goals, and business models.
• Responsible for setting up Cloudera Distribution 20 node Hadoop cluster and Analytics.
• Improved teh Office Patent Quality Assurance (OPQA) Patent Examination quality 30% by applying Generalized Linear Model detecting anomalies in Functional, Procedural and Formality using R.
• Built Knowledge Management and search tools on Solr dat has shrunk Patent applications responses by 40%
• Improved Patent audit process 500% by developing risk analysis process using R and Linear Regression Models.
• Supported peers and stakeholders as a Subject Matter Expert (SME) through troubleshooting, analysis of results,production support and identification of opportunities to solve problems.
• Applied R parallelism and multivariate analysis along wif 22 different traits/rules. Utilized package ‘Rserve’ connection between R and Tableau.
• Managed project team resources and influenced teh future direction of EIM information Hub solutions.
• Served as primary conduit for on-site, offshore teams and third party vendors.
• Managed BI Team and developed various visualizations comprising Bar charts, Line charts, Pie charts, Scatter plots, Gantt charts, Bubble charts, Histograms, Bullet charts, Heat map, Highlight tables, Treemaps, Box-and-whisker plots, Moving Averages and Donut Charts.
• Ensured compliance wif required policies and governances. Engaged wif Project/Program teams to ensure SDLC deliverables are met.
• Managed Data Warehouse, Data migration and ELT/ETL teams ingesting data into AWS Hadoop Data lake.
• Managed project issues and risks through standard issue/risk management process. Provided proactive and appropriate communication to stakeholders.
• Played key role in building Quantitative KPI s, Directional KPI s, Actionable KPI s, Categorical KPI s in Tableau.
• Strongly influenced teh future direction of EIM information Hub solutions. Provided benchmarks and inputs into decision making to keep teh solution current/leading edge.
• Managed projects wif dollar values in excess of $1M. Prioritized projects and delegated support appropriately.
• Partnered wif business units, technology centers, examiners, data scientists and development teams to translate potential data-driven ideas into fully developed business solutions.
• Blended data from multiple sources to discover new opportunities and presented them to Business Users and Executive team.
• Performed advanced analytics and data mining to identify insights and developed actionable insights.
• Disseminated knowledge about our capabilities to engender trust in teh project team and teh internal/external clients.

Confidential, NY, NY

Technical Project Manager

Responsibilities:

• Led discovery sessions to understand teh existing and desired business processes.
• Served as a liaison between multiple departments to facilitate project scoping, requirements gathering.
• Mentored and Managed team of 20+ resources operating across different geographies.
• Conducted consultative white-boarding sessions to help C level executives and business users understand roadmap of Big Data paradigm
• Optimized Data Warehouse by creating secure active archive data pipeline from CDW to EHDW/ODS saving $260,000 annual costs on new hardware and licensing.
• Improved teh performance of Transactions processing from 1 hour to 20ms which is near real time enabling Analysts to access data real time.
• Liasoned between teh big data team and teh business units. Leveraged expertise of team members throughout teh project duration.
• Presented comprehensive analysis and documentation of teh “As Is” state of operations and recommendations for optimal “To Be” state, supported wif operating ROI & TCO models.
• Created web-based requests for Business Analysts and Users for On-demand Data Marts, reducing waiting time for data refresh from 24 hours to real time besides eliminating data processing overheads.
• Demonstrated ability to provide technical oversight for large complex projects and achieved desired customer satisfaction from inception to deployment.
• Developed Tableau visualization and reported data findings creatively in a variety of visual formats dat appropriately provided insights to teh executive team. Potential for millions in savings through fraud detection and generated new business opportunities.
• Built High performance analytics at scale, for truly interactive analysis by Business Analysts bringing down response rates from 9 minutes to 20 ms.
• Medical Expense Analysis report is delivered via dynamic & interactive self-service Tableau dashboards. Time to deliver these reports cut down to 2 days what used to be 2 weeks.
• Created 360 view of teh Member/Customer Tableau dashboard for Case Management. dis has reduced time for Case Worker to prepare for initial call wif Member from 15 minutes to 10 seconds besides saving teh equivalent of time of 5 FTEs.
• Possess personal courage, commitment, assertiveness, self-reliance to face up to issues squarely and stand up for what teh project needs at all times.
• Analyzed and built solution architecture road map bridging teh AS IS and TO BE interfaces connecting EDW (Data Warehouse), NADW (Data Warehouse), MCM, SAP P24 (DX EMEA), SAP P45 (Germany) and SAP SPIRIDON (Rest of Europe).

Confidential, Summit NJ

Technical Analyst/Solution Architect

Responsibilities:

• Saved teh Siebel CTMS (Clinical Trials Management System) application from being shelved due to poor implementation for which management already spent 9 million.
• Built, managed and mentored team of 9 developers for both CRM and Business Objects and delivered functionality wifin a short period of 6 weeks.
• Built Inbound Subject data interface from external CRO vendors (ICON and Perceptive) using SOA/EAI/XML technology.
• Lead and Managed Vendor relationships wif regard to interface design and issue resolution.
• Provided direction/oversight and support to teh offshore and onshore team members working on DBA, Configuration, Integration, and Reporting tracks.
• Responsible for time and cost management, resource allocation, budget planning and tracking.
• Prepared SRS, Design, Impact Assessment and Validation documentation necessary to implement teh Change requests. Create CRs in Pilgrim system as part of process to implement them in Production.
• Worked wif CQA (Clinical Quality Assurance), Validation, Global help desk, DBA and Development teams to ensure teh software builds are migrated into TEST, Validation and Production environments on time.

Confidential, NJ

Tech Lead

Responsibilities:

• Migrate Chiron (New acquisition) Professionals and Accounts into Edge
• Design and develop EIM process to migrate MSA data dat include Catalogues, Categories and Access Groups,
• Provide tier 3 Production support to Edge(Siebel) application
• Build, Maintain and enhance Edge to SAMS/SFA interface dat include Products, Lots, New Shipments, Shipment updates and Inbound/Outbound Transfers
• Expert in Pharma Sampling Administration dat include Inventory Reconciliations, Transfer In, Transfer Out, Shipments, Disbursements, Returns, Adjustments and Inventory Count
• Manage offshore support team to ensure successful deployment and support services
• Manage vendor relationships
• Design, Develop and Implement CDM(Customer Driven Marketing) data migration into Edge system
• Develop UNIX Shell scripts and Schedule Batch loads for EIM - Control M.
• Configured and built EAI HTTP Transport, EAI Siebel Adapter and File Transport Adapters
• Developed Connector based integration using Siebel EAI and XML over HTTP methodology

Johnson Johnson, NJ

Sr. Consultant

Responsibilities:

• Design and develop Delta/Seed Validation process for Accounts in Siebel and ODS (Operation Data Source) based on Siebel LOVs
• Design and develop Informatica mappings to load teh Delta/Seed Accounts data from OCs( Operating Company) into Siebel and ODS
• Develop PL/SQL programs, LOV Table mappings to support Delta/seed validation process against Account Type, Account Sub Type, Sub Type Detail and IMS Sub Cat Code fields
• Design and Develop Sub Account name change and Merge teh resulting duplicate Sub Accounts through Siebel EIM process
• Design and Develop Siebel Business Service, Workflow Process, Workflow Batch Process, Repeating Components Requests for ongoing Sub Account name change and Merges resulting duplicate Sub Accounts

Confidential, NJ

Sr. Consultant

Responsibilities:

• 4-Year Bachelor Degree in Electrical Engineering, Andhra University, AP, India
• Certified Integration Core Consultant(SOA)
• Certified webMethods Integration Server Consultant
• Member, Data Science, Hadoop, NoSQL & NewSQL Database User Groups of New York and New Jersey

TECHNICAL SKILLS

Bi Big Data Ecosystems: Hadoop, HDFS, MapReduce, YARN, Pig, Hive, Impala, Sqoop, Zookeeper, Oozie, Flume, HBase, Cloudera, Hue, AWS EC2, Tableau, Pentaho, Cloud Computing, Spark, Kafka, Splunk, Navigator (Security), JSON, BSON, Avro, Parquet

Scripting Languages: Java, C/C++, JSP & Servlets, JavaScript, XML, HTML, OOPS, PL/SQL, SOAP, REST

Data Management: Master Data Management, Data Federation, Data Integration and quality management, Data governance & Data Movement (ETL/ELT)

Enterprise Reporting: EHDW, CDW, Data marts, OLAP & ODS, Web Reports, Mobile Reports & dashboards, Mash-ups, Database/ BI Support (DBA, ETL, ELT, Reports/ Dashboard Monitoring), SAP BO, IBM COGNOS

Visualization & Analytics: Dashboards, Strategic maps, Balance Scorecards, Data Mining, Predictive Analytics, Heat Maps, Analytic databases ( HP Vertica)

Data Migration: Pentaho, Informatica,, TAVIZ 2.1.1( ETL), Data Junction 7.5 (ETL), TOAD, SQL Navigator, SQLLDR

Databases: NoSQL Oracle RDBMS, MySQL, MS SQL Server, MS ACCESS

Tools: Eclipse, JDeveloper, JProbe, Toad, XMLSpy, Trillium, Putty, DMWare, SQL Navigator, SQL Developer, Apache, Yum, RPM, WebMethods, GitHub, Jira

Platforms: Windows, Linux, Solaris, CentOS, AIX, HPUX