SUMMARY:

• Over the last 8+ years, have gained a variety of expertise in the Information Technology field with a major focus on Data Analytics, Tableau, Hadoop, SSIS, SSRS,SAP BW/Business Objects and SQL Server.
• Excellent Data Analysis and Data Retrieval skills with Tableau reporting experience. Writing analytical SQL queries to perform data analysis, data validation and quality check.
• Planning and executing data driven projects to drive business decisions using BI Tools, Data exploration, Data Mining, Machine Learning and Business Analytics.
• Highly Proficient in writing SQL queries with various Data bases for Data Profiling and Validation.
• Hands on experience in machine learning algorithms with strong critical thinking and creative problem solving skills and a good programming experience.
• Strong working experience in the Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Capable to delve into the new leading Technologies like Big Data and Cloud Technologies.
• Excellent interpersonal skills, strong verbal and written communications skills - capable of developing well-structured communications and presentations.
• Demonstrated ability to effectively transfer knowledge to clients or team members and to create clear, concise documentation.
• Committed to excellence, self-motivator, fast-learner, team-player, and a prudent developer with strong problem-solving skills.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Linux

Languages: UML, SQL, HTML, XML, C, C++, Java, Visual Basic 6.0/.Net

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

SDLC Methodologies: RUP, Waterfall, Agile (Scrum, XP), RAD

ETL/BI: Informatica, Crystal Reports, Business Objects, Hadoop

Testing Tools: QTP, Mercury Quality Center, Rational ClearQuest, LoadRunner, WinRunner

Other Tools: Rational Rose, MS Visio, MS Office, Erwin Data Modeler, TOAD, Management Studio, PL/SQL.

Reporting tools: Business Objects, Tableau, Hadoop, Crystal Reports, and SSRS & PowerPivot.

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

Sr. Data Analytics

Responsibilities:

• Developed sourcing logic, codes, data flow processes, account linkage processes, return on risk adjusted capital processing, product derivation, customer segmentation, general ledger account processing, customer relationship management, parity centric house hold processing and related global and product level processes for SAP Bank Analyzer implementation as system of records for Confidential ’s financial road map
• Accessed, validated and developed SQL queries on Oracle, SAP and Teradata Data warehouse for MDM, account and transaction level verifications and sourcing and mapping of business objects and data elements in financial transactions, result data layers and source data layers
• Gathered business requirements for SQL server database and business intelligence.
• Developed data sourcing and element mapping and ETL logic for SAP bank analyzer reporting
• Analyzed, modified and converted abintio codes to IBM InfoSphere data stage development for SAP BA
• Designed for SQL server database by analyzing workflow charts and use case, class, interaction diagrams and design ERD, UI and data models
• Integrated Tableau with Teradata and created a Data Visualization and Analytics platform on Tableau
• Prepared and performed Unit, integration, system and user acceptance Test plans and tests using HP QC .
• Applied advanced analytics with data visualization for business intelligence.
• Mapped financial data to the company's proprietary format to be interpreted by machine learning based tools for automating financial analysis.
• Accessed and analyzed loan, insurance, cards, investment, deposit and related financial data on W, BW, BACARDI using teradata SQL assistant, TOAD for Oracle and SAP Bank Analyzer
• Analyzed and converted business requirements, high level design documents, low level design documents, business requirement document(BRD ) into Extraction, transformation and loading logic to SAP BA.
• Automated workflows using shell scripts to pull data from various databases into Hadoop.
• Created, escalated and resolved open items, dirt logs and business review protocols and performed gap and root cause analysis using traceability matrix for SAP bank analyzer implementation
• Owned data extract full cycle data sourcing through client sign off, following ASAP, RUP, DMAIC, perform document review( participate in JAD sessions) with SAP BA team, business team and ETL team
• Analyzed and designed SAP BA business workflow scenarios, data sourcing, mapping, and transformation
• Developed SAP BA use cases, activity diagrams, ERD, class diagrams, user screens, user stories.

Confidential, Dallas, TX

Data Analytics

Responsibilities:

• Gathered requirements, extracted the data, implemented logic and developed complex business reports using SQL server.
• Developed Entity Relationship Diagrams (ERD's) for the project using Visio 2010
• Supported various teams and processed multiple requests on a daily basis and managed constantly changing deliverables with extreme deadlines
• Implemented Hadoop data-lake for transactional data store and building Analytics/Insights on it using Tableau.
• Provided innovative solutions to extract and mine the data and developed macros to format the data
• Developed different data visualizations using Tableau and Qlikview and presented to the client
• Performed profound testing on the new features and modules of the internal tool
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Involved in Branch Operations specific data-mart as part of a Business Objects Universe which replaced the existing system of reporting that was based on exporting data sets from Teradata to Excel spreadsheets
• Devised strategic methodologies and designed processes to obtain data
• Standardized the data, imported the data in an internal tool to effectively analyze and generate reports
• Compiled the data, analyzed the data and developed several analytical reports for the senior leadership team
• Involved in development of Financial Business Use Cases from Business Requirements
• Highly involved in writing SQL queries for the call center to pull the members from the database depending upon the requirements
• Created Data Element Mapping document to help ETL development
• Developed Business Process Flow Diagrams using MS Visio
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process
• Worked on ETL design for various source systems
• Reviewed all the systems design by assuring adherence to defined requirements
• Performed research using SQL server and compiled and analyzed the data and developed reports.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies and involved in all SDLC stages under agile process in applications including Requirements analysis, implementation, testing, deployment and maintenance
• Wrote requirements for various reports to be generated and migrated
• Planned and defined Use Cases. Created Use Case diagrams, Scenarios and Use Case Narratives
• Researched upstream data sources and ensured all source data sources were attested by its owners
• Responsible for creating mapping documents required for the ETL team
• Created report specifications containing mapping to source data sources
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data
• Flat file conversion from the data warehouse scenario.

Confidential, Pleasanton, CA

Data Analytics

Responsibilities:

• Imported data from SQL Server and Excel to SAS datasets.
• Modified existing datasets using Set, Merge, Sort, formats, functions and conditional statements.
• Analytical function applied across data in multiple sources (Hadoop, Teradata, Excel).
• Involved in establishing connections to different data sources (SQL Server, Vertica, Teradata, SAP, Salesforce, Azure Cloud, and web site data) and pulling relevant data from these source systems for data modelling.
• Used SAS datasets to create reports using Proc Print, Reports, Proc Transpose, Proc Tabulate, Proc Import, Proc Freq and Proc SQL.
• SAS Visual Analytics enables you to gain insight from all your data, no matter the size of your data.
• Integrated suite of web applications that offers intuitive, drag-and-drop interactions, rapid, highly visual responses, and role-based access to functionality is done by SAS Visual Analytics.
• Created Dashboard Reports in SAS visual Analytics as per Clients Requirement.
• Performed the automated data driven testing using Winrunner.
• Studio (BIDS) and performance tuning of Stored Procedures and T-SQL Queries.
• Sorting, printing and summarizing the SAS data by modifying and combining SAS datasets.
• Developed various reports like daily input report, monthly reports Report procedure.
• Extensively used SAS/Macro facility to provide reusable programs that can be conveniently used to update reports.
• Proc summary, proc means, proc tabulate are used for report generation.
• Performed detail analytics while producing financial reports so that the financial data is checked and are accurate
• Generated reports, tables, graph to identify market opportunities and recommended business strategies based on analysis of internal and external data sets.
• Developed programs using the Libname statement and SAS Views to extract and report error statistics.
• Updated business specifications, created system flow charts and prepared test plans.
• Used Microsoft Access and Excel to provide output analysis data

Confidential, Reston, VA

Data Analytics

Responsibilities:

• Authored and architected a Business Intelligence Platform using Business Objects and Tableau for rapid delivery of reports and dashboards in an agile environment with shorter cycle times
• Evaluated various BI tools for efficient delivery of Business Intelligence solutions
• Implemented end to end automation of testing of Business Objects and Tableau Reports and Dashboards using Selenium and Cucumber.
• Developed several machine learning algorithms on Python: Anomaly Detection, Clustering and Local Outlier Factor to detect fraudulent activities in the data of more than one million transactions and compare results to business intuition.
• Implemented an end to end rapid deployment of reports in a Dev-Ops environment using Jenkins
• Developed a BI Strategy for Self Service model for the business users which includes training, Maintenance support and regular one on one sessions
• Implemented an efficient Tableau Architecture to support high volumes of data for the Business users
• Automated end to end Tableau Dashboard Refresh by integrating it with the Backend ETL Tasks for the first time in Confidential for any reporting platform
• Instrumental in transforming an enterprise reporting team into a Business Intelligence Competency Center.
• Extensive experience in T-SQL development including complex stored procedures, Tables, Cursors, Views, Indexes and User Defined Functions
• Experience with ETL (Extract, Transform and Load)
• Strong Data analysis and Data mapping skills for ETL Development
• Strong Dimensional Modelling and Data mapping framework experience
• Collected, Analyzed and documented requirements specifications from the users to design robust Business Intelligence reports
• Employed Agile project methodology on business intelligence projects for shorter cycle times and improved usability.
• Written complex SQL queries for querying data against different data bases for data verification process.

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Established a RUP (Rational Unified Process) centric business analysis methodology.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process' and revenue streams aimed towards problem solving.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
• Was responsible for indexing of the tables in that data warehouse.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Updated the impacted MS Access tables.
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Extensively worked in designing the Testing approach for the ETL process in the Credit Data Provisioning Enterprise Data Warehouse (CDP).
• Creation of the data mart from existing Operational data Store and other sources.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Assisted in presenting reports and analysis to help guide the management.
• Organized cross training of team members and users to become more responsive.
• Assisted in development of training materials for new technology and process improvements.