We provide IT Staff Augmentation Services!

Director - Integration, Analytics And Reporting Resume

3.00/5 (Submit Your Rating)

Louisville, KY

SUMMARY

  • Leading the team to support integration, analytics and reporting across all initiatives at Confidential
  • Led the enterprise data analytics platform and roadmap at Confidential ($5M initiative for phases 1 and 2)
  • Enterprise data architecture for the Customer MDM, Member self - service, Data quality program and Data warehouse at Confidential .
  • Launched three SaaS product offerings at Confidential to support online estate planning.
  • Developed the Agile software development and quality assurance functions at Confidential and Confidential .
  • Designed and built a new multi-tenant repository and data services library at Confidential that anticipated changes in the business model. The repository provided Confidential the capability to launch various new product offerings in the wellness, worker compensation benefits space, and collect customer preferences and feedback.
  • Designed and built the master data management framework for the membership domain at Confidential to support the 360 degree view of the customer needed by marketing, sales, customer support, account management and operations.
  • Designed and managed the consumer preference framework at Confidential to assist in personalized and accurate communication via email and phone.
  • Led the continuous improvement program at Confidential by implementing the standards for balance and control along with the Compliance team that helped in improving transparency for data exchanges internally and externally.
  • Launched the member data governance program at Confidential that has helped in improving the member matching process. This improvement has helped in better customer support, clinical and wellness program activities.
  • Designed a new-build clean up system at Lexmark to alleviate the product build issues and reduce rebuild time. Component product build versions were maintained depending on the active product configurations which saved a lot of rebuild time.
  • Designed a Decision Support System to help the KY Welfare-to-Work case managers reduce human bias in the decision making process and provide accurate work readiness plans in assisting clients to be work-ready.
  • Proficient in Agile, SCRUM and Waterfall SDLC processes.

TECHNICAL SKILLS

Platforms: Windows 10.0, 7.0, Vista, Windows XP, Windows Server 2000, Windows Server 2003, 2012, Windows NT 4.0, UNIX, Linux, Solaris, PalmOS, AppForge, MainFrame.

Languages: ASP.net 1.0, 2.0, 3.0, 4.0 and 5.0 (C# and VB.net), ADO.net, Java (Swing, J2SE 1.2/1.3/1.4/1.5 ), JDBC, ODBC, JNI, RMI, Visual Basic (6.0/5.0/4.0), ADO 2.5, C++, C, mobile VB.

Databases: Oracle 8i/10g/12c, SQL Server 2000/2005/2008 R2/2012/2014, Access, MySQL, PostgreSQL, DB2, TeraData, Azure SQL Datawarehouse (evaluation)

NOSQL technology: MongoDB, Hadoop, Hortonworks, Cloudera

Tools: Infogix Assure, Business Objects XI (Web intelligence R3.0-3.1), IBM Initiate 9.2/9.7, Sandcastle Help file builder, Team Foundation Server 2005/2008, Rational ClearCase, Rational ClearQuest, Subversion, Visual Sourcesafe, ANT, SQL Server Integration services 2005/2008/2014 , Informatica 9.0 (Data Profiling, Data Quality and Data transform), Finalist, Verimove, GeoCoding, Oracle data integrator 12C, BizTalk 2016.

Scripting Languages: XML, XSL, XSLT, HTML, CSS, ASP, DHTML, JavaScript, Ajax, VBScript, PhP, PL/SQL (2.x), COM+, COM, and Perl.

Development Environments: Visual Studio 2003, VS.net (2003/2005/2008/2012 ), Eclipse.

Utilities: XPath, SQL reporting services, Crystal reports, Install shield, FrontPage, VBA (Excel), SQL Loader.

Web servers: IIS (8.5/7.5/6.0/5.0/4.0 ).

Modeling Tools: UML, Enterprise Architect (EA), Visio 2003/2010, Lucid Chart

Transaction Server: MTS.

Protocols: SOAP (1.2/1.1), IP, TCP, UDP, RIP, ARP, HTTP, FTP, DNS, SMTP, BGP, Multicast (DVMRP, MOSPF, PIM, MASC/BGMP, Reunite), Adhoc routing protocols (SRP, ARIADNE, AODV, ARAN, Tesla, SAODV, Watchdog, Pathrater).

Architecture: Enterprise, SOA, Distributed, Cougaar, Master Data Management, TOGAF

Others: R programming, Alfresco CMS, Contract Express, MSMQ, Web services (Web methods), Windows services, Appdomain management.

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Director - Integration, Analytics and Reporting

Responsibilities:

  • Lead a team of 10 people to support the reporting, analytics and integrations functions in the organization
  • Health Harmony platform comprises of cloud based SaaS solution (Azure) that involves a clinical portal, mobile solution for patients, reporting and analytics platform for insights and integration with clinical systems like EMRs, EDCs and EHRs.
  • Data analytics (Prescriptive and Predictive)
  • Support ROI analysis for existing customer leveraging the Health Harmony platform
  • Support models that calculate confidence measures for patients enrolled on the Health Harmony platform
  • Lead population health analysis
  • Implementing machine learning algorithm for clinical notes.
  • Integration (Strategy and product transformation - PaaS)
  • Support EMR integration for patient enrollment, financial transactions, vitals information and health session programs
  • Support batch and near real time integration for the Health Harmony platform
  • Reporting (Data reporting architecture in cloud - PaaS)
  • Support reporting framework (self-service) for the Health Harmony platform
  • Support ingestion of external data like claims and provide ad hoc reports to customers
  • Data Governance strategy
  • Support compliance and security team in building out and implementation of the data governance rules for the organization

Confidential, Los Angeles, CA

Manager - Enterprise Architecture Analytics

Responsibilities:

  • Enterprise Data analytics platform reform
  • Phase 1: Led the current state assessment with stakeholders, elicited requirements (functional and non-functional), devised roadmap and traceability matrix, and designed future state architecture
  • Phase 2: Led the technical evaluation of platforms (RFP process), Proof of concept implementation leveraging Oracle data integrator (ODI), Hortonworks, Cloudera and Tableau
  • Lead population health modeling.
  • Led the concept of implementing machine learning algorithm for physician notes.
  • Implemented the SDLC process to manage change control for ODI code artifacts and database objects (set up source control environment, automated build, code migration process, test plan execution)
  • Built architecture artifacts representing the organization’s information architecture and data quality gaps
  • Led the technical team of 10 developers for the Research data warehouse that includes collaboration with external vendor and University of Southern California (USC)
  • Have experience in leveraging the IntelliBridge Enterprise that provides a single path to exchange data such as ADT, labs, orders, vital signs, alarms, and documents between our Cerner EMR and Philips clinical systems
  • Have been able to participate in creating a Standard Operating procedure and ISO13485 experience for Clinical research as part of the Research data warehouse project

Confidential, Los Angeles, CA

Enterprise Data Architect

Responsibilities:

  • Led the team of 20 members to deliver the first Customer MDM solution (product transformation)
  • Enterprise Customer Master Data Management architecture - IBM InfoSphere V11 with
  • Phase 1: batch implementation including 5 sources of customer data
  • Phase 2: SOA and real time integration (MDM services) with Customer Self Service as part of Farmers Digital strategy
  • Phase 3: Pub sub architecture for publishing Customer data changes using EAI product (IBM Integration Bus)
  • Data quality architecture focused on the Customer MDM program
  • Data architecture for reporting solutions (distribution - agent and agency reporting), data isolation patterns (California Super group) and other data warehouse initiatives
  • Evolved the data strategy for enterprise BI, Big data and data warehouse
  • Build the roadmap for data lineage and data governance to support business terms/definitions, business rules and provide traceability in data integration, data at rest and data visualization
  • Led the technical team of 15 members as part of the SalesForce data integration for enabling Customer Self Service capabilities (Digital strategy and Hybrid architecture)
  • Led the architecture team of 5 members as part of the Duck Creek data integration for administering Specialty product transformation
  • Led the data and application architecture team of 10 members to assist with the insurance platform migration strategy from home grown system to Guidewire for auto and home insurance products

Confidential, Louisville, KY

Sr. Technology manager Products & Services

Responsibilities:

  • Responsible for the product engineering department (research and innovation, software development process, software development team of 6 members - onsite and offshore, quality assurance, product services like documentation and training, collaboration with sales, operations and marketing, enterprise architecture - services and ETL, data architecture, and security audit)
  • Responsible for integration architecture for product design and implementations with partners like financial advisors, non-profit organizations and elder care
  • Product and project planning using Agile Scrum (timeline and resource forecasting)
  • Product technology R&D and build product roll out strategies like mobile implementation and stand-alone product offerings
  • Responsible for three SaaS products and the technical infrastructure that facilitates online estate planning, upsell and cross sell (The ecosystem provides for collaboration via vault sharing - Content Management system and user friendly interface to generate estate planning documents). Technologies involved are .Net 4.0, C#, Java script, JQuery, CSS, SQL Server 2008 R2, Contract Express, Alfresco, Subversion, JIRA and SSIS 2008
  • Collaborate with customer to meet the desired goals of the product implementations like pilot launches, product training and product integration/solutions
  • Manage hosting environment vendor RackSpace to provide a robust, and efficient product infrastructure as part of release management and product support
  • Worked closely with third party organization as part of the SOC 2 audit related to security, availability, processing integrity, confidentiality, and privacy of the SaaS platform

Confidential, Indianapolis, IN

Sr. Consultant in Information Management

Responsibilities:

  • Technical lead - continuous Data Quality improvement initiative for the Enterprise Data warehouse (TeraData), Operational systems (ODS) and Analytical systems
  • Governance program lead - master data management (IBM Initiate) in the consumer domain (data ownership, decision making, data producers, data consumers, compliance, architecture)
  • Performing data analytics - root cause analysis, trending and identification of improvement areas for the Enterprise Data warehouse
  • Completed the Continuous Improvement Practitioner certification
  • Developed and executed the Data Governance, Metadata management and Master Data Management framework for the Confidential membership domain to improve data quality and track data lineage by working with stakeholders from different departments (claims, membership, finance, compliance, clinical care and provider)
  • Performed risk assessment associated with members data (privacy, security, integrity, accessibility, missing data and data inaccuracy)
  • Trained business partners in using ASG’s Metadata management tools: metaGlossary and Rochade; and Confidential Metadata glossary to assist in Metadata management and maintain a single glossary across the organization and vendors
  • Leveraged Infogix Assure as an Enterprise tool to provide capabilities like balancing and reconciliation for the Enterprise Data warehouse to solve the business need of monthly data reconciliation and provide transparency into data exchanges

Confidential, Louisville, KY

Data architect

Responsibilities:

  • Led a team of 10 associates, 10 onsite contractors and 15 off shore contractors on various implementation projects
  • Implemented an enterprise Wellness solution (Business strategy and product transformation) to support a new line of business and integrate with existing business processes like rating, quoting, set-up (enrollment), consumer web experience, and customer support operation. Worked with various IT teams, external vendors and business units to complete an end to end implementation involving technologies like DB2, Mainframe, SQL Server 2008 R2, SSIS, Informatica Power Center 8.6, SSAS 2008, Business Activity Monitoring (BAM), SSRS 2008, IBM Initiate and .Net 3.0 (WCF services)
  • Implemented an enterprise solution to build the Person Master Data Management process and solution for Confidential ’s insurance business. The Master Data Management implementation involved technologies like IBM Initiate 9.2 upgraded to 9.7, along with data stewardship capabilities using the Initiate Inspector interface.
  • Implemented an enterprise service that provided features like address standardization (Finalist on Mainframe), NCOA address verification (Verimove on Windows) and GeoCoding (lat/long to support mobile activities) to assist in consumer mailing for the enterprise
  • Architected an enterprise solution that provides multi-tenancy and process isolation capabilities (multi-tenant model) for co-located membership data. This ensured that data was provisioned and serviced based on appropriate security context in real time as well as batch
  • Designed and maintained an enterprise level operational data store (SQL Server 2008 R2) that provides membership data to web portals, customer support applications, and ID card management and data vendors
  • Architected an end to end solution to capture consumer preferences around various products and communication options to support the 360 degree consumer view at Confidential . The implementation included technologies like Informatica, SSIS, SSRS, SQL Server 2008 and .Net web services
  • Designed and developed the data profiling techniques, data quality techniques, and data governance rules for key data elements in the Master Data Management model for customer.
  • Designed and built a BizTalk implementation to support decision making using eligibility business rules and application tracking
  • Technical project lead on various Humflex projects, an enterprise level .Net 2.0 Windows forms application, used by the Spending Accounts (SPAA) representatives for day to day business activities like group setup, payments, billing setup, HSA bank account information and transactions
  • Migrated multiple application projects from Visual Source Safe to Team Foundation server (TFS 2005) by following the Enterprise Architect standards at Confidential .
  • Designed and implemented web services for communication between SPAA and other departments in Confidential (as well as external entities like Chase and UMB banks for HAS information)
  • Supported and maintained the C# batch jobs that are associated with spending accounts letter generation and background business processes
  • Coordinated development effort with off-site team, Tata Consultancy Services, using work items in TFS for the multiple releases
  • Customized work item tracking in TFS to track development effort during the project life cycle (project management)

Confidential, Lexington, KY

.Net Software Engineer

Responsibilities:

  • Implemented a new build system that has automation build scripts (in Perl) and code repositories (in Subversion and ClearCase) to build CPD and PS&SD printer products. The implementation supported client interfaces via web pages (in ASP, Vb.net, PhP), and data stores like SQL Server 2000, Postgresql, and MySQL. The new build system was implemented in C#, using XMLhttp, XML/XSL rendering, JavaScript, web services, windows services, MSMQ, and SQL Server 2005
  • Analyzed the flaws in the build clean tool and re-implemented the windows service (in .Net 2.0) to use graph traversal technique while deleting the outputs of the build system on remote storage locations based on business rules
  • Designed and developed the tool (in ASP.net 1.x and C#) that allows product managers to include Microsoft certification files in a build system product prior to external delivery.
  • Design, analysis and development of a cleanup tool (as a windows service in .Net 2.0) that facilitates the removal of outdated content on the corporate intranet site based on business rules and graph traversal
  • Design and development of an App domain manager that allows active swapping of business DLLs without stopping the business services
  • Administration of SQL 2000/2005 databases and configuring database backup jobs (incremental snapshot)

Confidential, Lexington, KY

Research Assistant

Responsibilities:

  • Design, analysis and development of a High level elicitation process and tool (HLE), and the LIMBO tool (probability matrix generator), using HCI principles, to facilitate the ease of building Bayesian networks by eliciting information from the WtW case managers. The GUI development was in Java Swing (application and applet) and the back end is a prototype XML server built on top of Oracle
  • Design, analysis and development of a prototype XML file server that stores XML documents and supports querying in XPath
  • Design, analysis and development of an SQL like language (SPOQL) for a probabilistic database framework that is built upon Oracle. The data is stored and retrieved from the database in XML format
  • The tools developed are part of the software suite presented at the Intelligent Systems Demonstration (ISD) at the American Association for Artificial Intelligence (AAAI 2006) conference
  • Subversion was used for version control along with Eclipse as the development environment

We'd love your feedback!