PROFESSIONAL SUMMARY:

• Over Fifteen years of experience in design, development, implementation of enterprise database applications, data warehousing, business intelligence, data mining, predictive modelling, reporting, integration, master Data Management etc.
• Experienced in designing and building data solutions using various enterprise tools.
• Worked on various domains like health care, bio - medical and financials industries. Possess excellent business/client interaction and communication skills both written and verbal.
• Data ware housing, data modeling, analytical database design and development, building EDW, Data Mart etc. for health care, financial and scientific institutions. Experienced in building normalized and multidimensional data models employing Inmon, Kimball, Hub-Satellite, Data Vaults etc.
• Experienced using several commercial databases like Oracle, SQL Server, Sybase ASE etc.
• Experienced in setting up Data Governance Practices including Data Availability and Data Integrity, Master Data Management etc.
• Experienced Analyzing Data, Data Profiling, Data Pattern Recognition, Data Clustering, Creating Data Dictionary, Data Lineage etc.
• Experienced in developing data analytics using Big Data techniques like Hadoop, Hive, HDFS, Informatica Big Data etc. Experienced in building Hadoop based architecture including Data Lake etc.
• Designing and building Information Delivery platforms using Business Intelligence reporting tools such as SAP Business Objects, Cognos, Microsoft SSRS etc.
• Designed and developed Data Visualization of Big Data including Heat Maps, Scatter Plots, Word Clouds etc. using tools like Tableau.
• Building data mining and predictive analytics using both supervised and un-supervised learning methods including neural networks, naïve Bayes, market basket analysis, decision trees etc. using software like MS SSAS, Matlab, Statistica etc.
• Excellent working knowledge in building and deploying OLAP cubes, defining Key Performance Index, Goals, Trends and other key business intelligence parameters.
• Designing and building ETL workflows using tools like Informatica Power Center, Microsoft SSIS, Business Objects Data Services etc.
• Good working knowledge using Master Data Management tools including SQL server Master Data Tools, Informatica MDM etc.
• Good working knowledge in health care domain both on the payer and provider side, experienced building Population Health Management solutions etc.
• Excellent knowledge in building application including those in Java J2EE, Microsoft .Net, ASP, web applications etc.
• Excellent leadership skills, highly motivated team player, willing to learn with strong communication and organizational skills.
• Software Engineering practices like business requirement gathering, writing software requirement specification (SRS), prototyping, testing and quality assurance, writing BRD (Business Requirements Document), TDD (Technical Design Documents), BPO, offshore/distributed team management etc.
• Good understanding of UNIX, Linux, Solaris etc. operating systems including commands, shell scripting, networking, application installation/maintenance etc.
• Strong Analytical and problem solving skills delivering solutions using efficient algorithms.

TECHNICAL SKILLS:

Database ORACLE: 11g, 10g, Microsoft SQL Server 2014/2012, Sybase ASE 12.X

Big Data: Apache Hadoop, Hive, HDFS, Informatica Big Data.

Reporting: BO, Hyperion, Brio, Cognos, SSRS, Tableau.

Data Modeling: ERwin, Toad.

Data Analysis: Microsoft SSAS, Matlab, SPSS, Statistica.

ETL: Informatica Power Center 9.X, SSIS 2014/2016, BODS 4.0.

Data Architecture Inmon 3NF, Kimball, Hub: Satellite, Data Vault.

Methodology: Agile, Object Oriented Analysis and Design (OOAD), Rational Unified Process (RUP), Software Oriented Architecture (SOA)

Technologies: .NET, JAVA (J2EE), Apache Struts, Servlets, JSP, JDBC, JFC/Swing, XML, JAXB, XSLT,LDAP

Languages: SQL, C#, JAVA, C++/C, PL/SQL, Perl, Visual Basic, Matlab.

Development Tools: Eclipse, J Builder, Microsoft Visual Studio.

Operating Systems UNIX, SUNSolaris, HP: UX, IBM-AIX, LINUX, Windows.

Version control: GIT, Clearcase, CVS, PVCS.

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, MI

Information Architect

• Interview various SMEs within each business functionality and come up with information and data elements.
• Standardize various data elements to align them globally based on the data element intent.
• Standardize data, establish data governance and Master Data Management around standardized data.
• Coordinate with external vendors (Dun & Bradstreet) who were engaged to perform Master Data Management on Businesses globally.
• Design and develop Global Enterprise Data Stores to have a unified view of Fleet Customers globally.
• Designed and developed the Fleet segment of enterprise Hadoop Analytics platform using Data Lake design pattern.

Healthcare Analytics Architect

• Interacted with various stakeholders and business/department leads to bring the requirement to a consensus.
• Designed and aided in building a Common Platform to unify data from various payers into a single format. This included Eligibility, Claims and Provider data from various payers.
• Designed data Integration Platform to integrate data from several different sources. Built a Common Platform, defined common fields and accommodated different sources to comply to the common platform.
• Defined Data Standards, interacted with various vendors and established a data governance and data compliance contract to attain uniformity across the sources.
• Designed and assisted in building Automation frame work to automate running all data loading and data processing tracks. Automation included scheduling, execution, notification and error handling.
• Formulated Data Governance practices to ensure data Availability, Integrity and Security of data across multiple Healthcare Providers.
• Provided Master Data Management (MDM) solutions to match and build a Master Patient Index across several sources.
• Designed reporting application utilizing Java/J2EE frameworks and ORM tools like Hibernate.
• Set up a proof of concept Big Data system using Hadoop HDFS and Hive. Used other supporting tools like Hue, Informatica Big Data, Informatica MDM etc.

BI/Reporting/Integration Architect

• Responsible to Design a Hybrid Style Data warehouse. Worked on a heterogeneous Oracle and SQL Server environment.
• Responsible to establish Data Governance across the Enterprise, attained a common definition and view of data across multiple departments.
• Responsible to Design and development of Big Data systems including Apache Hadoop, Hive and Mongo DB. Designed and implemented custom Map-Reduce jobs to enable certain high CPU intensive queries.
• Implemented Change Data Capture (CDC) on SQL Server 2012 in order to integrate the data with other systems.
• Responsible to Design Big data visualization of weather patterns using Tableau.
• Responsible to Design ETL data integration between the various source systems using Informatica.
• Responsible to put in place a data Standards and Data Governance practice using MDM tools like Informatica MDM.
• Responsible to design a reporting system for information delivery.
• Responsible for creating and maintaining documentation using wiki.

BI/Data Architect

• Integrate CPDM data with HEDIS engine to enable BCBSM to be NCQA certified.
• Integrate CPDM with CAVE (Episode grouper).
• Integrate CPDM with supplementary data (Chronic Kidney Disease centers, Lab work etc.).
• Interact with Data stewards and established uniformity in data across the various sources that CPDM feeds data from.

Business Intelligence Architect

• Responsible in business analysis, requirements gathering, writing business requirements document, technical design document etc.
• Responsible for designing the data warehouse in MS SQL 2008.
• Responsible for designing ETL processes and mappings using Microsoft SSIS.
• Designed and developed various data mining models to associate, cluster and segment data using Microsoft SSAS.
• Designed Business Intelligence reporting using Microsoft SSRS.
• Responsible to document all the projects including Technical Design Documents, Business Requirement Documents, Test Documents etc.
• Responsible for developing security roles, provisioning etc.
• Responsible for interfacing with Microsoft sharepoint workflows etc.
• Responsible for working with a distributed team of analysts, data architects etc.

Environment: / Tools: Microsoft SSAS, SSIS, SSRS, SQL 2008, Toad data modeler, Biztalk, Sharepoint VB .NET.

Senior Software Engineer

• Responsible for designing the FSA data mart as part of the existing multi dimensional database running on Oracle 10g. Involved in designing the data model, data flow diagrams etc. for the FSA database using a star schema approach.
• Designed and implemented indexing schemas including BITMAP indexes for low cardinality high volume data.
• Designed and developed reporting /extraction process to extract FSA records and send them to the respective vendors using Hyperion/Brio.
• Responsible for designing and developing Informatica mappings and workflows for the third party vendor extraction process. Wrote complex reusable mappings, complex transformation algorithms, custom joins etc to extract high volume data.
• Responsible for detecting data changes, surprising data values, data exploration and explanation through data mining algorithms etc.
• Responsible to document all the projects including Technical Design Documents, Business Requirement Documents, Test Documents etc.
• Responsible for aiding in scheduling batch extracts using IBM Tivoli scheduler.
• Responsible for designing and developing J2EE Struts application for web access.
• Responsible for bringing together an offshore development team, conducted conference calls, JAD sessions etc.

Environment: / Tools: Oracle 10g, Toad data modeler, Java/J2EE, Informatica, SSIS, Shell Scripting, Hyperion/Brio, Tivoli etc.

Senior Software Engineer

• Responsible for designing and developing Analytical Data Ware House running on Microsoft SQL 2005.
• Wrote the Data Loading/data analyzing scripts to load and analyze data onto the data warehouse from OLTP database.
• Developed ETL Data Mapping to map data from OLTP to OLAP database using SSIS and Informatica ETL package.
• Responsible for developing and maintaining various OLAP cubes for Business Intelligence reporting and analysis.
• Made revisions to parsing programs to parse 835 and 83 7s.
• Wrote stored procedures to support the data processing engine in database intensive operations like complex joins, pivoting, query performance tuning, partitioning, parallel querying etc.
• Responsible for developing and enhancing Business Intelligence reporting using Cognos Business Intelligence Dashboards and Microsoft Reporting.
• Responsible for writing scripts to facilitate scheduled tasks, pre processing files/scrubbing etc. These text processing were much easier to be done through scripts rather than VB .NET - used Bourne / BASH shell scripts and AWK to preprocess / scrub files, etc.

Environment: / Tools: Shell Scripting, MS SQL 2005, Cognos, MSAS, SSIS, Informatica Power Center 8.X.

Senior Software Engineer/ Team Leader

• Designed multi dimensional database for the storage of Genes, Vectors, Enzymes etc.
• Designed indexing schemes, parallel querying, data partitioning etc to keep data retrieval time minimum.
• Designed and developed various data mining procedures to enable intelligent querying.
• Devised Milestone Planning and Risk Assessment.
• Devised recommendations, trends and KPIs.
• Implemented high performance, efficient algorithms to perform vector annotation from over 10 million genes on the fly. All algorithms were designed and developed to run and complete in an interactive manner (within a 10 second interval).
• Administered best practices in SCM (Source control management) using CVS.
• Designed and developed front end Struts application for web access.

Environment: / Tools: SQL server 2000/2005, MS Analysis Services, MDX, C/C++, Java J2EE Struts.

Software Engineer

Responsibilities:

• Designed Oracle 8i database schema back end system to store secure payment information.
• Developed presentation layer based on Java Struts Framework.
• Designed and developed secure payment programs.
• Designed/developed scheduled emailing system, recurring billing etc.

Environment: / Tools: Oracle 8i, Java, SSL, Linux, Perl, PHP.

Software Engineer

Responsibilities:

• Designed and developed Matlab programs to read DICOM images, build 3D models.
• Designed and developed ROLAP multi dimensional database to hold 3D models.
• Developed special algorithms, dynamic programming paradigms etc.
• Developed database query interface to enable the user to run smart queries on the database.

Environment: / Tools: C/C++, Oracle 9i, Matlab, Linux, CGI, Perl, Apache web server.

Software Developer

• Wrote technical/functional specifications to translate client’s requirements into existing software.
• Performed change impact analysis and prioritized changes.
• Enhanced database structures, indexes, performance tuning etc.
• Audited software projects and instituted software process and procedures that improved the Quality control and certification initiatives undertaken by the organization.

Environment: / Tools: Solaris 2.8, C++ Ver 5, Java Servlets, Sybase ASE

Software Developer

Responsibilities:

• Involved in documentation task through reverse engineering.
• Involved in writing software Requirement Specification.
• Involved in development of new OLTP database system along with stored procedures etc.
• Followed systematic software development milestones, code management (CVS), system integration etc.
• Involved in documenting the new system, building an intranet knowledge management system helping in training the new users to use and maintain the new system.

Environment: / Tools: IBM OS390, Java J2EE 2.X, Sybase, EJB, JSP