SUMMARY

• 5+ years of IT experience as a ETL Developer, predictive analytics, Data Analyst, and Data Modeler and policy and Credit analyst.
• Have good experience working with ETL & Reporting tools like SQL Server Integration Services (SSIS), Talend for Data Integration, Toad Data Modeler, Tableau, QlikSense and Power BI.
• I have excellent knowledge about the Data analysis, predictive modeling and exploratory data analysis.
• Have very good experience working in Agile Environment.
• Have solid experience in Exploratory Data Analysis.
• Very good understanding of ML techniques and algorithms.
• Have excellent knowledge about the data mining and statistical method that are used in data analysis.
• Performed data analysis, statistical analysis, predictive analysis and generated reports listings and graphs using R Language, Excel, and Tableau, Qlik Sense.
• Raw Data Extraction, Cleaning, Transformation from multiple nodes in XML format.
• Experience in integrating R with Tableau and visualize data models and GGPLOTS in R. Build Statistical Models in R and connecting with Databases like MySQL and SQL Server.
• Experience in Interpreting data, analyzing results using statistical techniques and providing ongoing reports.
• Experience working with large datasets and efficiently handling the datasets to find the necessary business decisions.
• Solid Understanding of Machine Learning Concepts like Regression, Decision Trees, KNN, Random Forest, Clustering, Bagging and Boosting, Bayes Decision, Neural Networks, timeseries Analysis.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts, and methodologies.
• Worked on developing the Dimensional Modeling and transferring the data from Entity - relationship modeling to Dimensional Modeling.
• Experience with Data Modeling, creating Star & Snow-Flake Schemas, Fact and Dimensions Tables, Physical and Logical Data Modeling.
• Experience in building Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Services(SSIS).
• Used Talend Data Studio to perform ETL operations data from 4 different databases to one single database
• Developed the ETL jobs to load the data from the flat files to Staging area
• Developed the application for data warehouse and business intelligence platform for dashboard reporting.
• Lead the ETL development procedure and monitored the development of the ETL processes
• Developed and designed the ETL processes and built the jobs required to integrate the data.
• Build the ETL jobs to integrate the data from one database to the other database using SSIS and Talend.
• Have excellent experience with Data cleaning and data processing, Master Data Management
• Experience in data staging and the masking/scrambling of sensitive data within staging areas
• Linked the data warehouse tables to BI tools like PowerBI, Tableau to create the necessary BI dashboards and Reports.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Have close to 2 years of experience in RDBMS skills and databases like Oracle, SQL Server, My SQL
• Experienced in gathering business requirements from clients /end users and converting them into SQL stored procedures for database specific projects.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.
• Experience with SQL, PL/SQL, and database concepts.
• Experienced in maintaining the data governance and End to End Data Quality.
• Ability to work in team in diverse/ multiple stakeholder environment

TECHNICAL SKILLS

Operating System: Microsoft Windows 2000, XP/Vista,7,8,10, UNIX

Databases: Oracle 11G, MySQL 6.3, Microsoft SQL Server 2016, PostgreSQL 9.6

Languages: R-Language, HTML, JavaScript, Java Server Pages, SQL, Java, HTML, CSS, C++

Tools: and Applications: R-Studio, Minitab17, Microsoft Excel, SPLUNK, Microsoft Project, Eclipse HP SM, HP QC, RAD, RSA; Eclipse, HP Service Manager, HP Quality Center, Jenkins, Microsoft Office, Excel Power Pivot, Excel Data Explorer, Crystal Reports, Power Pivot.

Data Warehousing Tools and Applications: Talend Data Integration, SSIS, Toad Data Modeler; SSRS.

BI and Reporting Tools: Tableau Desktop, PowerBI, QlikSense, PowerPivot, IBM Watson Analytics

ML Algorithms: Regression, Decision Trees, KNN, Random Forest, Clustering, Bagging and Boosting, Bayes Decision.

PROFESSIONAL EXPERIENCE

Confidential - Boston, MA

Responsibilities:

• Studied the ER model in which the source data is stored.
• Designed the Dimensional model by implementing all the concepts related to Data warehousing.
• Developed the Facts and dimensions table and carefully designed the star schema and snowflake schema.
• Experience working with Talend Basic components, Data processing, Transformation and ETL Processing.
• Created Talend Jobs with the help of Talend Data Studio and created Custom components using Talend DI tool.
• Created the Talend jobs to connect the source databases to the destination databases.
• Experience in data staging and The masking/scrambling of sensitive data within staging areas
• Clean the jobs once the integration process is completed all the data is moved to the dimensional model.
• Automated repeatable processes & reports using ToadDataPoint & VBA Macro.
• Load and transform large sets of structured, semi structured and unstructured data
• Analyzing different user requirements and coming up with specifications for the various database applications
• Monitored the performance of the Talend jobs and checked on the execution time.
• Identifying issues with the database and resolving them
• Connected the database to the reporting software like Tableau and PowerBI to generate the necessary dashboards.
• Created reporting dashboards using the reporting tools like Tableau, PowerBI extensively.
• Developed and reviewed SQL queries with use of join clauses in Tableau.
• Created the dashboards related to the number of sales based on region and based on the categories of the products they were manufacturing.
• Managed the data with the help of PowerBI and made the hierarchies with the help of PowerBI.
• Designed the Dimensional model for school’s database to create a data warehouse to perform reporting
• Used Talend Data Studio and SSIS to migrate data from four different DB’s (Oracle, SSMS, MySQL and Postgres) to MySQL DB
• Performed the BI operations and reporting to answer the business questions related to sales and profit/loss etc. using Tableau, PowerBI.

Confidential - Boston, MA

Responsibilities:

• Gathered the necessary data required to perform the regression analysis.
• Studied each variable and understood the importance of each variable in determining its importance in predicting the outcome.
• Prepared testDatasets and performeddatatesting using the SQL scripts. Also, used MS Excel fordatamining,datacleansing,datamapping,datadictionary anddataanalysis.
• Applied design of experiments methodology in studying the behavior and performance of nylon climbing ropes.
• Tested and Analyzed the design of experiments model with the help of graphical indicators, surface, and contour plots.
• Analyzed R-Sq And Adjusted R-Sq Values to determine the accuracy of the data model.
• Applied Hypothesis Testing, Regression Analysis, and ANOVA methodologies to identify significant factors in the model.
• Studied the Contour plots in determining the behavior of the variables and the model.

Confidential - Boston, MA

Responsibilities:

• Collected the necessary data which will be used to perform the necessary data analysis on the problem.
• Each variable is studied carefully and determined what’s the importance in predicting the outcome of the variable.
• All the necessary variables are retained and unnecessary data is taken of.
• Performed the Principle component analysis on the data set to reduce the dimensions and reduce the number of variables.
• Cleaned the data further and we have divided the data into Training and test data to perform the testing and the validation of the models which are going to be built.
• Applied the classification and regression tree algorithm in the data to predict the overall price of the car.
• Determined most important car specifications needed to predict the price of used Toyota Corollas through Classification and Regression Trees.
• Predicted the prices of Toyota Corollas using Classification Tree and compared them with Regression trees.
• Analyzed two other Algorithms for same data and evaluated the accuracy of all the models used.
• Created the bins for the continuous data into 20 different bins and then preformed the Classification trees on the same data to verify if the Regression tree is predicting accurately
• Analyzed the results which were generated and tested the model to see if the prediction is accurate.
• Performed the random forest methods to fine tune the trees to improve the accuracy of the model and reduce the inaccuracy of the model.

Confidential

Sr. Software Engineering Analyst/Business Analyst

Responsibilities:

• Experience on performing data analysis and creating source to target mapping document, including business logic (data rules)
• Worked on the Dimensional Modelling with the help of Data modeling tools.
• Tested the data warehouse with various testing process.
• Worked on Designing and building the solutions of multitude applications including batch processing, Job processing, OLAP, and data warehousing Architecture.
• Worked on Performance tuning of different ETL processes and ETL jobs.
• Have very good experience setting up the ETL Processing and ETL environment.
• Built proof of concept dashboards to show how the final dashboards are going to look like.
• Have working knowledge across the technology stack including ETL, data analysis, metadata, data quality, audit and design
• Ability to collaborate with peers in business and technical areas to deliver optimal business process solutions in line with corporate priorities.
• Experience working in Agile and/or Waterfall methodologies
• Gather the requirements from the client team and document them effectively to make sure the documents are reusable.
• Involved in ETL process of extraction, transformation and loading of data from different source systems.
• Work with client team on a day to day basis to figure out any defects occurring in the client application.
• Proactively fixed the defect which the users are facing with the application.
• Responsible for Monitoring and Tuning the performance of the code.
• Worked on developing the data warehousing jobs to migrate data from multiple sources to a target source.
• Have very good knowledge about Hadoop environment.
• Have very good knowledge about the Java Integration and interface knowledge.
• Responsible for handling the Incidents and working with the client team to make sure that the functional issue is being resolved.

Confidential

Associate software Engineer

Responsibilities:

• Responsible for providing the on-call support and in providing the support of high priority defects in the application.
• Worked as an offshore coordinator to help the onsite team in providing the effective support for the client.
• Responsible to understand the required documents which are used to build the frontend Java web application.
• Modify the UI specs based on the client changes and the requirements changes for the application.
• Study the new concepts of Dojo framework and knowledge about the portal architecture.
• Implement the portal architecture and implement the Dojo- framework in designing the front-end applications.
• Write the HTML code to build the Java server pages and the Portlets.
• Implement the security to the Java server pages to restrict the access to the pages for different user types and roles.
• Used Jasper reports to implement the reporting aspect of the documents.
• Developed the Sales Incentive planner application which AHM will use to provide the incentives to the dealers.
• Implemented Dojo Framework, Portal Architecture, JSP, HTML, and Portlets to develop the Incentive Planner application
• Created dashboards using dealers data which was extracted by SQL scripts in IBM DB2 to find the insights
• Collaborated with the client to clarify and create the knowledge item documents to improve quality deliverables.
• Managed all the defects of the application with the help of HP Quality Center and categorized the defects according to the priority.
• Developed the Controllers and deligators to connect the front-end and back-end.
• Developed Web Service client interface for invoking the methods using SOAP.
• Collected the data related to the number of claims that the client is processing and gathering all the necessary information to make the valid decision.
• Modified the existing stored procedures to implement the new changes and RFC’s that the client suggested.
• Extensively used Eclipse IDE for developing, debugging, integrating and deploying the application
• Changed the data with the help of SQL queries to increase the speed in processing of the claim.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Diagnosing and resolving database access and checking on performance issues
• Scheduled the overnight jobs to make sure that the high severity tickets are not generated and cleaning the scheduled jobs once they are completed.
• Actively involved in different stages of Project Life Cycle. worked in Agile environment taking in consideration the frequent change in data requirements from the client.
• KT with the client to understand their various Data Management systems and understanding the data.
• Presenting the reports to the client and the Sr. management of Confidential .