SUMMARY:

• Confidential is having solid 18 years of IT experience in Software Development Technical Production support and Maintenance Projects.
• Providing data - driven,solutions to challenging business problems Business-minded.
• Highly accurate and experienced Data scientist adept at collecting, Analyzing and interpreting large data sets, developing new forecasting models and performing data management tasks. Possessing extensive analytical skills, strong attention to the detail, and significant ability to work in team environments.
• Very good Hands on Microsoft Applications like Dot Net, MSSQLServer & MSBI.
• Excellent analytical skills, organizational, interpersonal skills, Identification and negotiation for Business and Technology requirements.
• Results oriented professional, recognized for taking on major initiatives, and adapting to rapidly.
• Changing environment and resolving mission-critical issues to ensure bottom-line success.

TECHNICAL SKILLS:

Operating System: MS Windows

Programming Languages: Python, .Net, VBData 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

Other Utilities: AWS SageMaker, Big data - Hadoop, Hive, Pig, Map reduce, Crystal reports, Active Reports

PROFESSIONAL EXPERIENCE:

Confidential, Farmington, Connecticut

Data scientist & BI Developer

Responsibilities:

• 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 modeling 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.
• Applied in-depth knowledge of systems and products to consult and advise on additional efforts across organization/enterprise.
• 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.
• Setup SQL database on a cloud server, storing client's data for query analysis.
• Used Python's sci-kit-learn library to understand the details of a client telemarketing campaign.
• 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.
• 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.
• Ensuring the timely deliverables of Data extracts to Vendors as per agreed timeliness. Working with all stakeholders and ensured the Development, Testing and Production deployment completed as
• Worked as Vendor implementation manager for Connecticare and Emblem external Clients.

Confidential, St Louis, MO

Business Intelligence Developer & Technical Application Support Lead

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

Business Intelligence Developer & Technical Application Support

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
• Implement updates of reports in BeneSmart application to recognize same-day data updates/changes.
• Doing release builds and fixing issues related to reports in staging environment of BeneSmart application.
• Created data driven subscriptions for different users using Report Manager.
• Proficient with Dynamic HTML, XML, CSS, for building a dynamic flexible and highly interactive Real-Time User Interface.

Environment: Windows Server 2008 R2 Enterprise, .Net, SQL Server, MSBI, VB

Software Engineer

Confidential

Responsibilities:

• Designed and developed static websites using HTML, CSS and JavaScript.
• Designed, developed and published 100s of static and dynamic websites.

Environment: VB.Net, ASP.Net, MS SQL Server, MS Project 2000, Crystal Reports