SUMMARY:

• Results - driven hands-on technology manager with over fifteen years of IT experience in leadership, management, consulting, specializing in enterprise BI, Big Data solutions implementations and software development.
• Award of Excellence for Exemplary Leadership and Vision from various Organizations with proven track record of continuous achievements.
• Responsible for management, strategy, delivery and growth of BI and analytical solutions.
• Designed and developed Big Data systems using Cloudera.
• Experienced in Scala and the Apache Spark platform (including Spark Streaming, Datasets, MLlib, GraphX)
• Fluency in modern data storage, messaging, and processing tools (Kafka, Cassandra)
• Agile methodologies to incorporate changes to meet the health care compliance.
• Successfully implemented multiple IT projects ranging from $50K to $2M, provide the technology knowledge and vision to support the company's business objectives, and evaluate and recommend all software for business processes.
• Able to influence the strategic direction of the company by identifying opportunities in large, rich data sets and creating and implementing data driven strategies that fuel growth including revenue and profits.
• Direct management of 16+ on-site and offsite/off-shore team members, including assignments, guidance and skill development and being accountable for setting up goals and evaluating the performance metrics of all direct reports.
• Budget management for IT projects and operations
• Provides leadership and technical expertise to multiple development and cross functional teams.
• Regular update to stakeholders on the project status and progress of development efforts.
• Conduct regular reviews with Product management on release scope and schedule.
• Best talent recruitment, salary negotiation, onboarding, and Personal Action Form process.
• Request for quotation, proof of concept, review proposals and SOW.
• Inspire, motivate and maintain long term relationship in a team-oriented, results-driven environment consisting of a group of talented and passionate multinational engineers across different locations.
• Worked in Healthcare, Biotechnology, Manufacturing, and EHS verticals.
• Proven success in elevating service levels, enhancing staff productivity, and achieving key organizational objectives by demonstrating authentic leadership in fostering a culture of accountability, collaboration, open communication, and customer service excellence.
• Excellent communication and interpersonal skills expedite the development of highly productive professional relationships throughout all organizational levels spanning both internal (e.g. business units, development groups) and external entities (e.g. customers, vendors, auditors).

TECHNOLOGY PROFICIENCIES:

Business Intelligence: ETL, SSAS, SSRS using MS SQL Server, Performance point Dashboard, PowerView, PowerBI, Tableau 9.0/10, QlikView,Data Warehouse, Informatica, Cognos.

Web Technologies: ASP.NET 4.0/4.5, AJAX, MVC, C#.NET, AWS, Java Script, REST, SOAP.

Big Data Ecosystem: Apache Hadoop, MapReduce, HDFS, HBase, Apache Spark, Hive, Cloudera Impala, Pig, Sqoop, Cassandra, HQL, Flume, YARN, Hue.

Data Science and Tools: Python, R, Machine Learning Algorithms, MatLab, Octave, Microsoft Azure ML Studio

Security Implementation: SAML IdP 2.0 (from Secure Auth), AuthN/AuthZ

Databases: MS SQL Server, NoSQL, MySQL, Oracle, Teradata.

Others: Service Oriented Architectures (SOA), Application Life Cycle Management (ALM), Azure Machine Learning suite.

PROFESSIONAL EXPERIENCE:

Confidential, Stockton, CA

Manager - BI/Big Data and Analytics

• Provide technical guidance in Data Ingestion, Data Processing, and Data Analysis.
• Manage and provide operational support for the Business Intelligence solutions.
• Deliver stunning analytical reports using any of the available Microsoft BI tools, Tableau, PowerBI.
• Participate in Big Data initiatives like maintenance of the Hadoop system, Cloudera Data Management, using interactive SQL with Aache Impala, Spark Streaming for near real time data.
• Architect scalable and feasible data analytics solutions in consideration with technical feasibility.
• Develops department goals based on established objectives, participating with peers to ensure effective integration; implements associated action plans.
• Plans and assigns work; makes timely and effective adjustments as required as well optimization of the data warehouse.
• Provide Leadership to development team and responsible for design and technical work of Business Intelligence solutions and Data Integrity.
• Provide insight of Utilization and Disease management using machine learning algorithms.
• Use Spark Streaming for processing near real time disease management in compliance with HEDIS and NCQA.
• Supervises or performs quantitative and qualitative analyses/evaluation on a variety of complex and diverse strategic and operation issues.
• Develops and prepares effective decision support tools and models for accurate evaluation of performance and to assist in management decision-making.
• Collaborates with external and internal stakeholders to maintain the validity and integrity of data sources.
• Compiles, develops and submits or oversees the compilation, development and submission of internal and external reports.
• Provides technical expertise to other areas including, but not limited to, Clinical Programs, Finance and Contracting.
• Develops or assists in the development of department budget; manages budget for area of responsibility.
• Develops and implements unit policies and procedures that promote best practice; makes recommendations on revisions; communicates to appropriate individuals in a timely and effective manner.
• Promotes and maintains, and ensures that direct reports promote and maintain an environment that supports Confidential ’s vision, mission and values.
• Hires, develops, supervises and retains an adequate and competent staff.

Environment: Performance Point Services, ETL, SSAS, SSRS,Visio, Agile, Hadoop, Cloudera CDH3, MapReduce, Hive, Pig, Sqoop, Impala, Flume, Kafka, Splunk, Business Intelligence, SQL Server, Team Foundation Server, ASP.NET, C#.Net, IIS, Management, Training and Education, SharePoint 2013, Visual Studio, SAML IdP 2.0, Web Services, Microsoft Azure Machine Learning Studio, Python, R, Scala, Spark Streaming, MS Project Server, Jira, Java, PowerBI, MVC, Tableau 9.0/10.0.

Confidential, San Ramon, CA

Manager - Applications and Business Intelligence

• Provide Leadership to development team and responsible for design and technical work.
• Produced performance/compliance trend reporting, capacity forecasting, and margin analysis using advanced analytics/modeling production reporting.
• Responsible for incubation and growth of Big Data initiatives.
• Provided technical guidance in Data Ingestion, Data Processing, and Data Analysis using various Apache and Cloudera Tools.
• Ability to write and do code review the R/Python/Scala/Java programming modules.
• Used Apache Spark's scalable machine learning library MLlib for RDD- based APIs for various supervised learning algorithms, and DataFrame-based API.
• Implemented few algorithms to track ACO for improving health care quality and control rising costs by analyzing Providers, Claims, and member's measures value.
• Objectively communicated complex risk minimization initiatives and performance tracking analytics to various audiences (internal audit, LOB leaders, and senior management) using Performance scorecard.
• Lead Agile development activities and responsible for timely and effective deliverables by the team within sprints given.
• Coordinated with Infrastructure team for fine tuning Hadoop, BI server resources and scalability.
• Deploy and Schedule MapReduce jobs on Hadoop cluster, ingesting near real time data using Kafka with Spark Streaming.
• Estimated work effort, skills/resource requirements and developed high level and detailed project plans.
• Provide weekly status reports and schedule meetings with all the stakeholders and management team to review the projects over all status.
• Support and maintain existing applications and manage the development of new modules and migrating to existing production systems.
• Managed onsite/offshore teams, Hired and mentored BI and application resources.
• Splunk power user for tracking and analyzing production server environments.
• Provided effective training and education for customers on BI Tools and their usage
• Implemented Single Sign On security logon feature at Enterprise level using SAML IdP 2.0 protocol.
• Directed daily operations as well as analyze, propose, plan, and manage all critical IT initiatives.
• Manage staff by providing career guidance, mutually constructive performance appraisals, and ongoing career development opportunities.
• Drive cost reduction initiatives including vendor discount negotiation and application/server/license consolidation.
• Set up the goal in alignment with the company’s goal, evaluate the performance yearly and provide appraisal for the outstanding employees.
• Provide technical leadership for Vendor technical discussions with the internal tech team.
• Provided excellent story lines across time spans using Tableau for effective analysis and data predictions which lead to maximum profit by taking appropriate measures.

Environment: Visio, Agile, Hadoop, Cloudera CDH3, MapReduce, Hive, Pig, Sqoop, Impala, Flume, Kafka, Splunk, Business Intelligence, SQL Server, Team Foundation Server, ASP.NET, C#.Net, IIS, Management, Training and Education, SharePoint 2013, Visual Studio, SAML IdP 2.0, Web Services, Microsoft Azure Machine Learning Studio, Python, R, Scala, Spark Streaming, MS Project Server, Jira, Oracle, Java, PowerBI, ETL, SSAS, SSRS,MVC, Tableau 9.0/10.0.

Confidential, Vandergrift, PA

Technical lead/ Project Manager

• Managed team of developers responsible for delivering various solutions and improvements for the business community.
• SME for BI dashboards and ATI’s web applications. Lead data modeler for Pricing and Revenue data store. Interacted extensively with developers, quality assurance engineers, and project teams regarding scheduling, requirements, design, implementation, testing, and support.
• Efficiently delivered the Business Intelligence Solutions in SSIS, SSRS and SSAS using SQL Server 2008R2/2012 for business demands to perform ETL, access/view the information and to make decisions based on analyzing the data warehouse in the form of Cubes.
• Technical Leader for various projects thereby assuming and taking responsibilities in bringing up new technology aspects/advantages into the existing systems and provide Client Interaction and satisfaction.
• Good knowledge in understanding and using the Team Foundation Server 2010 architecture and components for team builds and administration.
• Maintained software applications and managed the operational defects and its timely fix and release.
• Informatica administration of security and setup of repository structures
• Created dimension views and User Class views to implement the data security in the Cognos Powerplay Transformer Model
• Delivered presentations and training to users on use of BI tools and reports.
• Maintenance and enhancements of Biztalk applications using Biztalk Server 2006/2009.
• Data modeling, Code Reviews, Technical Design, Application Architecture and POC, Mentoring, and training.
• Developed dimensional data to represent invoice information for all the products to drill through based on sales date, order date, product type, Line Of Business etc.,. Generated various BI Dashboards to analyze the trend and regional variation in sales and revenue
• Created dimension views and User Class views to implement the data security in the Cognos Powerplay Transformer Model
• MS Visio is used to create the Data model and ERD.
• Worked extensively with Web Services, Linq to SQL, MVC, XML, XSLT.
• Significantly worked on maintaining the web Applications using ASP.NET, C#.NET using .net framework 3.5/4.0 with SQL Server 2008R2. Providing Production Support and Project Management.

Environment: Visio, Agile, Business Intelligence, SQL Server, Team Foundation Server, ASP.NET, C#.Net, IIS, Leadership/Management, Training and Education, SharePoint 2013, Visual Studio, Web Services, Python, MS Project Server, Jira, Oracle, Java, PowerBI, ETL, SSAS, SSRS,MVC, Tableau 9.0.

Confidential, Pittsburgh, PA

Content engineer

• Part of the Content Engineering and Data team for providing effective ingestion, processing, and analyzing of the marketing data.
• Processed large sets of structured, semi-structured and unstructured data using ETL using Informatica into reliable and desired information to be consumed for the Marketing Catalogue.
• Provided interactive dashboards and reports using Informatica and Cognos based on the Business needs.
• Developed custom tools to convert the large dataset of Product images from chemical format (SVG) to .jpg format. Created dashboards and reports using Cognos, and SSRS to provide details of daily/weekly changes to the Products DataMart. Maintained Web Services and .Net applications and Java programs.
• Maitained Java application for enhancing the features or modules for printing the Marketing catalogue.
• Strong experience in Business Intelligence using SQL Server 2005/2008.
• Applied Core java skills to fix the issues and maintain the existing Java application using Eclipse.
• Develop and maintain related data conformance validation scripts.
• Strong experience with XML DTDs/schemas
• Maintenance of Internet Information Server (IIS).
• Applied the knowledge Informatica in generating the reports on time with efficiency using normalization
• Worked on DDL, DML, T-SQL, PL-SQL, views, stored procedure, triggers, functions and packages and SSAS, SSRS, and SSIS in SQL Server 2005/2008 and Oracle 8i/9i based on business plans.
• Created roles, profiles and privileges and assigned roles to users.
• Worked on scheduling the jobs.
• Informatica administration of security and setup of repository structures
• Created dimension views and User Class views to implement the data security in the Cognos Powerplay Transformer Model
• Delivered presentations and training to users on use of markup
• MS Visio is used to create the Data model and ERD.
• Developed solution to automate processes for converting the SDFdata into the SVG images using PERL scripting.

Environment: Visio, Business Intelligence, SQL Server, Team Foundation Server, ASP.NET, C#.Net, IIS, Leadership/Management, Training and Education, SharePoint, Visual Studio, Web Services, Python, Pearl, Oracle, Java, PowerBI, ETL, SSAS, SSRS,MVC, Informatica PowerCenter 8.5, Cognos, XML Spy, Eclipse.

Confidential, Ossining, NY

Senior Software Engineer

• Developed “Competency Assessment Test” web application to assess the knowledge gained by the analyzer in
• sample analysis after providing sufficient training for certain period. Also developed a program to sequence the DNA samples in a plate. Maintained internal and external facing web applications.
• Maintain and troubleshoot algorithms and scripts for robotics for analyzing DNA samples.
• Gained knowledge on the terms and technologies used in the Biotechnology.
• Worked on web-based applications using ASP.NET, VB.NET, ASP with Oracle 9i and SQL Server 2005 as backend.
• Good programming experience in Transact SQL, SQL, PL/SQL, Complex Stored Procedures, Triggers.
• Installed Oracle, apply patches, and create/setup databases.
• Maintenance of Internet Information Server (IIS).
• Oracle 8i/9i Database Implementation/Upgrade/Support.
• Migration of Data from SQL Server 2000 to SQL Server 2005
• Performance tuning using SQL Query Optimizer
• Creation of roles, profiles and privileges and assigned roles to the users
• Supervise a team of Software Engineers throughout the Project Lifecycle.
• Involved in performance appraisal of the software engineers
• Use of COM and DCOM Objects to establish the security of data connection in the applications through IIS
• MS Visio is used to create the Data model and ERD.
• Regular DBA activities like Backup and Restoring of the Database by either Hot/Cold, Import/Export
• Proficient in using the Jscript and VBScript in performing the client side validation
• XML and XSL style sheets has been used for manipulating the user data as per the business plans.

Environment: Visio, SQL Server, Visual Source Safe, ASP.NET, C#.Net, IIS, Leadership/Management, Training and Education, Visual Studio, Web Services, Pearl, Java, PowerBI, ETL, OLAP, SSRS,MVC, Informatica PowerCenter 8.5, Cognos.

Confidential

Senior Programmer Analyst

• Lead developers for enhancing and delivering various ASP.Net modules in an Environment, Health, and Safely application. Acted as scrum master for releases.
• Developed various packages using ETL for heterogeneous data. Developed SSRS reports. Actively participated in Data Migration from SQL Server 7.0 to SQL Server 2000.
• Good programming experience in Transact SQL, SQL, T-SQL, Complex Stored Procedures, Triggers.
• Installed SQL Server, apply patches, and create/setup databases.
• Maintenance of Internet Information Server (IIS).
• Performance tuning using SQL Query Optimizer
• Creation of roles, profiles and privileges and assigned roles to the users
• Use of COM Objects to establish the security of data connection in the applications through IIS
• MS Visio is used to create the Data model and ERD.
• Regular DBA activities like Backup and Restoring of the Database using Enterprise Manager.
• Generated reports using Crystal Reports
• Proficient in using the Jscript and VBScript in performing the client side validation

Environment: Visio, SQL Server, Visual Source Safe, ASP.NET, C#.Net, ASP, IIS, Leadership, Training and Education, Visual Studio, Crystal reports, ETL, SSRS.

Confidential

Officer Systems

• Developed Web and Windows Applications using ASP, VB as front end and SQL Server, and Oracle as the backend.
• Developed various crystal reports to meet the business needs for viewing and analyzing the manufacturing products and its details.
• Provided technical support for internal and external applications and tools used in Delphi-TVS.
• Multiple desktop applications have been developed using the Visual Basic 6 with Oracle as backend.
• Good programming experience in Transact SQL, SQL, PL/SQL, Complex Stored Procedures, Triggers.
• Maintenance of Internet Information Server (IIS).
• Performance tuning using SQL Query Optimizer.
• Creation of roles, profiles and privileges and assigned roles to the users.
• Created and Executed the Batch programs for importing and Exporting the data in scheduled jobs.

Environment: Visual Basic, ASP, Visual Source Safe, IIS, Visual Studio, Crystal Reports, MS Access VBA, Visio.