SUMMARY:

• Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and VBA).
• Excellent knowledge and usage of reporting tools such as Tableau.
• Experience in data scrubbing and cleansing.
• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM using SharePoint Tracker and IBM Rational).
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Self - motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
• Exceptional organizational and time management skills and the ability to work independently.
• Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.
• Utilize business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and Excel.
• Experience in data analysis and ETL techniques for loading enormous amounts of data.
• Experience with data mining.
• Identify issues when reports are created from several and complex data sources.
• Perform data modeling, data migration, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snowflake, Fact and Dimension Table, Physical and Logical Data Modeling using Erwin 3.x/4. x.
• Excellent knowledge and usage of statistical/mathematical analytics software like R Statistical Software, SPSS, Matlab.

TECHNICAL SKILLS:

Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64)

Databases: MS SQL Server 2005/2008/2012 , Teradata 12/13, MySQL 5.2, 5.7Oracle 9i, 10g, 11g

ETL/Other Tools: Informatica 9.5.1/9.6.1 , SAS Base 9.x, R Statistical SoftwareSAS, SSIS (Visual Studio), UNIX Shell Scripting, Erwin Data Modeler, ER Assistant

Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, SQL Developer, Toad, PL/SQL

Querying language: SQL, PL/SQL, TSQL

Business Intelligence: Tableau 9.3,10.0, 10.1, Excel and PowerPivot, SSRS

PROFESSIONAL EXPERIENCE:

Confidential

ETL Informatica Developer

Responsibilities:

• Designing and developing ETL with informatica power center processes for data warehouse; from the acquisition and staging of data, storing records within the warehouses historical archive and transforming records for loading into the reporting tables
• Experience in monitoring the environments and suggesting improvements for stability and performance tuning.
• Created business rules in Informatica Developer and imported them to Informatica power center to load the standardized and good format of data to staging tables.
• Communicated with business customers to discuss the issues and requirements.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Confidential, Boston, MA

ETL Informatica Developer/Analyst

Responsibilities:

• Created complex PL/SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.
• Experienced in optimizing performance in relational and dimensional database environments by making proper use of Indexes and Partitioning techniques.
• Designing and developing ETL with informatica power center processes for data warehouse; from the acquisition and staging of data, storing records within the warehouses historical archive and transforming records for loading into the reporting tables
• Performed various operations like Data Cleansing, Data Scrubbing, Data Profiling and maintained data governance
• Experience in monitoring the environments and suggesting improvements for stability and performance tuning.
• Created business rules in Informatica Developer and imported them to Informatica power center to load the standardized and good format of data to staging tables.
• Communicated with business customers to discuss the issues and requirements.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Confidential, Pittsburg, PA

Data Analyst/ Data Architect

Responsibilities:

• Wrote queries to fetch data from different table by using joins, sub-queries, correlated sub-queries and derived tables on SQL Server platform.
• Extensive experience in designing the Data models for OLTP & OLAP database system. Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin, ERStudio.
• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, group by and OLAP (Online Analytical Functions).
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Used SAS to import and export data from and into SQL Server tables.
• Used Pivot tables to create reports that performed dicing and slicing functions on data. This is called dimensional analysis and gives business a 360 view of what is going on.
• Developed leading routines and data extracts with Informatica and SAS and SQL procedures.
• Involved in the performance tuning of database and Informatica and improved performance by identifying and rectifying the performance bottlenecks.
• Extensive experience in Database Design, Normalization, Selective De-normalization, Forward/ Reverse Engineering of Applications, Conceptual, Logical and Physical data modeling using Erwin, E/R Studio .
• Carried out data extraction and data manipulation using SQL as per business requirements.
• Performed ETL mapping and designed transformation document as per business requirements with informatica.
• Developed and implemented strategies to handle errors by the ETL teams.
• Extracted data from flat files, Oracle, DB2, and SQL Server 2014, and loaded the data into the target database.
• Developed automated tool for updating and running quality checks on ERWIN data models.
• Created logical and physical models using ERWIN.

Confidential, Framingham, MA

Tableau Developer/Analyst

Responsibilities:

• Used Tableau Server as a frontend BI tool and MS SQL Server 2012 as a backend database to design and develop workbooks, dashboards, global filter page, and complex parameters-based calculations.
• Worked with team of developers and designed, developed and implemented a BI solution for sales, product and customer KPIs.
• Gathered business requirements and translated them into functional requirement for ETL process.
• Carrying out data extraction and data manipulation using SQL as per business requirements.
• Performed ETL mapping and designed transformation document as per business requirements with informatica.
• Created compelling dashboards using Tableau dashboard and prepared user stories to deliver actionable insights.
• Connected Tableau Server to publish dashboard to a central location for portal integration.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau workbooks from numerous data sources using Data Blending.
• Developed Tableau visualizations and dashboards using Tableau Desktop.

Confidential

Junior Analyst

Responsibilities:

• Worked with a team to design, develop and maintain employee and servicing client databases using MS Access.
• Prepared reports using advance Excel functions.
• Used Power Pivot as a data mining tool to obtain business requirement.
• Used lookup and data validation in Excel to generate servicing client billing reports.
• Modeled occupational injury with SPSS.
• Worked with a team to design and optimize shortest path for dump trucks from crushing plants to waste dumps.