SUMMARY

• Adroit in learning new technologies; Ability to work both in independent and collaborative milieu.
• Proactive approach in initializing and accomplishing the tasks.
• Adept at working in high - pressure environments with strict deadlines and multiple deliverables.
• Sound communication skills through patient and persistent dialogue; Disciplined, versatile, and big picture thinker.
• Extensive knowledge in machine learning, artificial intelligence, statistics, and data mining
• Experienced with Machine learning algorithms with Python3.5(NumPy, Pandas, Matplotlib and Sci-kit-learn), Decision Tree, Random Forest, Logistic Regression, Linear Regression, Multiple regressions, Cluster Analysis, Neural Networks, KNN, SVM, k-means from Mathematical perspective, Sklearn for machine learning or deep leaning and NLTK for NLP.
• Hands on experience in implementing Forecasting/ Predictive Analytics, Segmentation
• Methodologies, Regression based models, Factor analysis.
• Expertise in transforming business requirements into analytical models, designing algorithms,
• Building models, developing data mining and reporting solutions that scales across a massive volume of Structured and unstructured data.
• Involved in the entire data science project life cycle and actively involved in all the phases including data extraction, data cleaning, statistical modeling, and data visualization with
• Large data sets of structured and unstructured data.
• Skilled in Advanced Regression Modeling, Multivariate Analysis, Model Building,
• Actively involved in Gathering, Detailing, Documenting and Managing requirements from project inception through production migration.
• Ability to prioritize and multitask while working on time sensitive deliverables, provide leadership to accomplish the work and meet deadlines.
• Excellent communication, analytical and problem-solving abilities with clear understanding of system development life cycle and proven project management skills.

TECHNICAL SKILLS

Operating System: MS Windows

Programming Languages: Python, .Net, VB

Data Mining: Python - Numpy, Pandas, Skitlearn, Matplotlib, Jupyter, Notebook,Scipy

Statistical Machine Learning: Statistical Analysis, Linear Logistic Regression, Clustering

Databases & Tools: MS Sqlserver, MSBI (SSIS, SSAS, SSRS),Snowflake, Tableau PowerBI, PostgresSQL, Talend

Other Utilities: AWS Sage Maker, Big data - Hadoop, Hive, Pig, Map reduce, Crystal reports, Active Reports, DataMeer Spectrum

PROFESSIONAL EXPERIENCE

Confidential, St Louis MO

Data Engineer

Responsibilities:

• Extensively used ETL Components to Extract Data from Different Sources.
• Design and development of SSIS packages to fetch data from different data sources.
• Creation of reports using prompts/ combined queries, report level filters.
• Working on Test cases of SSIS Packages and Data cleansing.
• Developed C#, VB.Net scripts as part of ETL coding.
• Development of UNIT test cases and prepared technical specifications for SSIS packages.
• Creation of source Queries at Analysis and Designing phase.
• Preparation of mapping documents and technical design documents based on client requirement specifications.
• Creating merged dimensions at report level by using multiple data providers.
• Testing of reports for data validation at different levels and preparation of Test results document.
• Universe and Reports Migration from Dev to UAT to Prod
• Worked in performance tuning and deployment phase.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.
• Developed different type of reports by using SSRS and SQL Server 2008/2014.

Confidential, Farmington, CT

Data Engineer

Responsibilities:

• Work independently and collaboratively throughout the complete analytics project lifecycle, including data Extraction/preparation, design, and implementation of scalable machine learning analysis and solution and Documentation of results.
• Provided strategic leadership for the development, validation and delivery of algorithms, statistical models and Reporting tools. Acted as the analytic team lead for highly complex projects involving multiple resources and tasks, providing individual mentoring in support of company objectives.
• Lead the development and execution of new and/or highly complex algorithms and statistical predictive models and determines analytical approaches and modelling techniques to evaluate scenarios and potential future outcomes.
• Established analytical rigor and statistical methods to analyze large amounts of data, using advanced Statistical techniques and mathematical analyses. Managed highly complex analytical projects from data exploration, Model building and performance evaluation and testing.
• Experience in using statistical computer languages (Python) to manipulate data and draw insights from large data sets
• Used sci-kit learn, ran linear regression, and built a model of Healthcare data performance
• Based on the model, identified two distribution companies whose revenue outperformed peers.
• Used machine learning algorithms to build a model able to predict which clients to engage based on a variety of client, macro, and campaign-specific characteristics.
• Enterprise Data Management - Development of all Vendor Data extracts of CCI.
• Care Centrix PAC Program - Development of Claims, Enrollment, Provider, Groups & Lab data extracts.
• New Century Health OCM Program - Development of Claims, Enrollment, Provider, Groups & Lab data extracts.
• ESI Medicare & Market Prognosis Program - Development of Claims, Enrollment, Reconciliation, Auto Group load, QMB extracts.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for generating reports using SSIS, SSRS.
• Setup SQL database on a cloud server, storing client's data for query analysis
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Strong experience in migrating other databases to Snowflake.
• Experience with Snowflake Multi - Cluster Warehouses.
• Understanding of SnowFlake cloud technology.
• Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading nested JSON formatted data into snowflake table.
• Experience in building Snowpipe.
• Experience in using Snowflake Clone and Time Travel.
• Participates in the development improvement and maintenance of snowflake database applications
• Build the Logical and Physical data model for snowflake as per the changes required
• In-depth knowledge of Snowflake Database, Schema and Table structures.
• Define virtual warehouse sizing for Snowflake for different type of workloads.
• Worked with cloud architect to set up the environment
• Coding for Stored Procedures/ Triggers.
• Designs batch cycle procedures on major projects using scripting and Control
• Develop SQL queries SnowSQL
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
• ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQL Writing SQL queries against Snowflake..
• Closely working with category for implementation master data management (MDM) of new products, customers, and vendors. Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• As part of Transformation project from Amisys source to Facets - managed all the data extracts development and Worked closely with all teams in resolving the challenges faced during the development and Testing phases.
• Worked on Risk Adjustments projects like Wakely and RSM. Involved technically and as SME of Legacy applications, Supported Dev teams through Dev phase and shared the application knowledge.
• Worked closely with CMS teams on RA vendors, Compliance Projects like BCRC, VDSA.
• Working closely on all technical related issues that Vendors are reporting and ensuring that they are resolved.
• Working with all stakeholders and ensured the Development, Testing and Production deployment completed.
• Worked as Vendor implementation manager for Connecticare and Emblem external Clients.

Confidential, Chicago, IL

Data Engineer

Responsibilities:

• Developed optimized stored procedures, MS-SQL queries, User Defined Functions (UDF), Cursors, Views and Triggers, SQL Joins and other statements for benesmart reporting Application, maintained referential integrity and implemented complex logic.
• Enhancing the layouts available for the reports in the BeneSmart application.
• Designed and created Report templates, Bar graphs and Pie charts based on the financial data.
• Dealt with huge amount of data and used SSAS in order to retrieve the data.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2014.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS. Gather requirements from business user and modify the stored procedures, codes to provide functionality as required.
• Perform including filters to the reports and make it parameter-driven. Perform including SQL Agent jobs to update Source of data by use of SSIS package.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL). Deploying the reports to staging server prior to business user acceptance testing. Perform including security to the reports and data in the application.
• Created data driven subscriptions for different users using Report Manager.

Confidential, Raritan, NJ

Business Intelligence Developer

Responsibilities:

• Provided Technical Support for all the key 64 IMS applications and completely managed the Support Teams.
• As a SME of more than 30 applications, provided several Innovative solutions and Value adds to the existing Applications.
• Designed User Interfaces. Frame Work Development &Customization
• Involved in several key enhancements and maintenance activities. Completed within agreed timescales and met the Clients expectations.
• Managed the fast paced growth in the number of processes and the expansion of existing business processes and gained the Client’s appreciations.
• Responsibility for all the deliverables of the projects and ensuring to adhere to SLA agreed.
• Other KRAs were Enterprise Change Management, Project Planning, Resource Planning and Mobilization, Managing Deliveries and resolving dependencies, Client Relationship Management and internal interfacing for project requirements.
• Deliver the project within estimated budget and timescales, Involved in preparation of SLAs.