SUMMARY

• Over 15+Years of IT experience.
• 10+ years of experience in the field of Business/Data analysis, ETL Development, Data Modeling, and Project Management.
• Proficient inData Analysis, Cleansing, Transformation, Data Migration, Data Integration, Data Import, and Data Exportthrough use of ETL tools such as Informatica.
• Analyzed data and provided insights with R Programming and Python Pandas
• Expertise in Business Intelligence, Data warehousing technologies, ETL and Big Data technologies.
• Experience in Creating ETL mappings using Informatica to moveData from multiple sources like Flat files, Oracle into a common target area such asData Warehouse.
• Experience in writingPL/SQLstatements - Stored Procedures, Functions, Triggers and packages.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Skilled in Tableau Desktop versions 10x for data visualization, Reporting and Analysis.
• Developed reports, dashboards using Tableau for quick reviews to be presented to Business and IT users.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Hands on learning with different ETL tools to get data in shape where it could be connected to Tableau through Tableau Data Extract.
• Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions.
• Researched data anomalies in complex business systems, develop audit reports, provide reports and recommendations for correction of data, and develop business and technical processes to ensure data integrity.
• Strong understanding of the principles ofDatawarehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling
• Expertise in writingcomplex SQL queries, made use of Indexing, Aggregation and materialized views to optimize query performance.
• Performed predictive Modeling, Pattern Discovery, Market Basket Analysis, Segmentation Analysis, Regression Models, and Clustering.
• Experience in working with SAS Enterprise Guide Software for reporting and analytical tasks.
• Experience in utilizing SAS Procedures, Macros, and other SAS application for data extraction using Oracle and Teradata.
• Expertise in using Qlikview
• Cloudera certified developer for Apache Hadoop. Good knowledge of Cassandra, Hive, Pig, HDFS, Sqoop and Map Reduce.

TECHNICAL SKILLS

Etl Tools: Informatica Power Center, SQL * Loader, Ascential,Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Data Modeling: Erwin 4.0, Power Designer, Microsoft Visio 2003, ER Studio

Databases: Oracle 10g, 10g, MS SQL Server, MS Access, Teradata

Operating Systems: Windows and UNIX, Sun Solaris, AIX, HP

Business Modelling Tools: Salesforce, SharePoint.

Programming Languages: SQL, PL/SQL, Visual Basic, Net, C, C++, UNIX Shell Scripting, XML

Reporting/Dss/Analysis: Business Objects 5.0, COGNOS 7.0 and Crystal Reports, BO, OBIEE, SSAS, SSRS and Excel, SAP HANA.

BI Tools: Cognos 8, Micro Strategy, Business Objects, Microsoft SQL Server Reporting Services, Tableau, Web Focus

Others: MS Project, MS Office, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Sanjose, CA

Sr Data Analyst

Responsibilities:

• Devised simple and complex SQL scripts to check and validate Dataflow in various applications.
• Performed Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Exportthrough Python.
• Devised PL/SQL/Pig/Hive statements - Stored Procedures, Functions, Triggers, Views and packages. Made use of Indexing, Aggregation and Materialized views to optimize query performance.
• Developed logistic regression models (using R programming and Python) to predict subscription response rate based on customers variables like past transactions, response to prior mailings, promotions, demographics, interests and hobbies, etc
• Created Tableau dashboards/reports for data visualization, Reporting and Analysis and presented it to Business.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• Worked with the Business development managers and other team members on report requirements based on existing reports/dashboards, timelines, testing, and technical delivery.
• Knowledge in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.
• Developed dimensions and fact tables for data marts like Monthly Summary, Inventory data marts with various Dimensions like Time, Services, Customers and policies.

Confidential, MI

Sr Data Analyst/Tableau Developer

Responsibilities:

• Experienced in developing business reports by writing complex SQL queries using views, volatile tables
• Experienced in Automating and Scheduling the Teradata SQL Scripts in UNIX using KornShellscripting.
• Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Extensive experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 7.0, 8.0,8.3,9.0 and 10 as a Developer and Analyst.
• Worked on Offshore-Onshore Model.
• Interaction with the Client and End User to Understand the Requirement and design the high and Low-Level documentation.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Design and prototype of accurate and scalable prediction algorithms using R/R Studio
• Analyzed different types of data to derive insights about relationships between locations, statistical measurements and qualitatively assess the data using R/R Studio
• Data Profiling to help identify patterns in the source data using SQL and Informatica and thereby help improve quality of data and help business to understand the converted data better to come up with accurate business rules.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Implemented Indexes, Collecting Statistics, and Constraints while creating table
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Confidential, GA

Sr Data Analyst

Responsibilities:

• Interacted with business users to identify and understand business requirements and identified the scope of the projects.
• Identified and designed business Entities and attributes and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Developed normalized Logical and Physical database models for designing an OLTP application.
• Enforced Referential Integrity (R.I) for consistent relationship between parent and child tables. Work with users to identify the most appropriate source of record and profile the data required for sales and service.
• Involved in defining the business/transformation rules applied for ICPdata.
• Define the list codes and code conversions between the source systems and the data mart.
• Developed the financing reporting requirements by analyzing the existing business objects reports
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models.
• Created XSD's for applications to connect the interface and the database.
• Compare data with original source documents and validate Data accuracy.
• Used reverse engineering to create Graphical Representation (E-R diagram) and to connect to existing database.
• Generate weekly and monthly asset inventory reports.
• Evaluated data profiling, cleansing, integration and extraction tools (e.g. Informatica)
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality
• Also Worked on some impact of low quality and/or missing data on the performance of data warehouse client
• Worked with NZ Load to load flat file data into Netezza tables.
• Good understanding about Netezza architecture.
• Identified design fl in the data warehouse
• Executed DDL to create databases, tables and views.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Involved in Data Mapping activities for the data warehouse
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Extensively worked on Performance Tuning and understanding Joins and Data distribution.
• Experienced in generating and documenting Metadata while designing application.
• Coordinated with DBAs and generated SQL codes from data models.
• Generate reports for better communication between business teams.

Confidential, Michigan

Data Analyst/Tableau Developer

Responsibilities:

• Gathered data and business requirements from end users and management. Designed and built data solutions to satisfy application requirements
• Developed reports, dashboards using Tableau 8.3 for quick reviews to be presented to Business and IT users.
• CreatedScatter Plots,Stacked Bars, Box and Whisker plots using reference, Bullet charts Heat Maps, Filled Maps and Symbol Maps,Pareto chartsaccording to deliverable specifications.
• Implanted the analyzed data into Tableau and show the regression, Trend and forecast in the dashboard for the classified industries which was considered.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Analyzed huge volumes of data .Experience with various ETL, data warehousing tools and concepts. Created data warehouse design.
• Involved in extensive data validation by writing several complexSQLqueries and Involved in back-end testing and worked with data quality issues.
• Created source to target data mappings, business rules, and business and data definitions.
• Developed dimensions and fact tables for data marts like Monthly Summary, Inventory data marts with various Dimensions like Time, Services, Customers and policies.
• Used Informatica & SAS to extract, transform & load source data from transaction systems, generated reports, insights, and key conclusions.

Confidential, MI

Data Analyst

Responsibilities:

• Involved in meetings with SME's, DataArchitect and Datamodelers in getting the Business Requirements.
• Extensively used both Star Schema and Snow flake schema methodologies in building and designing the logicaldatamodel in Dimensional Models.
• Designed and Developeddata mapping procedures ETL-Data Extraction,Data Analysis and Loading process for integratingdata using Informatica.
• Defined the relationship between primary and foreign keys in tables
• Performed statistical analysis using SQL, SAS and Excel
• Closely interacted with developers to understand application functionality and navigational flow and keep them updated about Business strategies.
• Designed and implemented basic PL/SQL queries for testing and report/datavalidation
• Import, clean, filter and analyze data using tools such as SQL, HIVE and PIG.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Participated in code reviews with team members and third party vendors. Lead and mentored junior level QA team.
• Effectively Communicated plans, project status, project risks and project metrics to the project team. Planned test strategies in accordance with project scope.

Confidential

SAP ABAP Developer

Responsibilities:

• Technical expert, ensuring quick turnaround in identifying application issues and providing timely solutions. Develop detailed plans and accurate estimates for completion of build, system
• Testing and implementation phases of project. Transform business function requirements into technical program specs to code
• Test and debug programs. Develop, code, document and execute unit tests, systems, integration
• Acceptance tests and testing tools for functions of high complexity. Perform performance tuning to improve performance over multiple functions
• Engage other technical team members in the design, delivery, and deployment of solutions.
• Manage operational support, performing work during change windows as well as providing on call support as required by the team. Undertake performance tuning activities for SAP integration activities.
• Mentor and coach junior developer resources.