SUMMARY

• Proactive, innovative & highly analytical professional wif 8+ years of Information Technology industry experience.ExpertiseinBusinessAnalyticswifexcellentleadershipskills,problem - solvingability,performancedrivenapproach,and a passion for turning data into valuableinsights.
• In-depth noledge of Software Development Life Cycle (SDLC) Methodologies including Agile, Scrum, Kanban, and waterfall.
• Experienced in liaising wif business and technical stakeholders and coordinating wif cross functional teams to meet teh business objectives.
• Strong1 noledge of Data Analytics, Quantitative & Statistical Analysis, Data Warehousing, Data Modeling and Database Management.
• Good noledge of writing SQL & BI reporting tools (Tableau, Power BIetc.)
• Implemented complex business rules using Informatica PC transformations, Workflows/Worklets, Mappings/Mapplets, and parameterized teh environment for better handling of data control for users as well as production support team. Documented Test Plans, Test Strategies and Test Cases for various Data Warehousing projects implementation.
• Knowledge and practical experience in SAP SD/CS like master data, sales, deliveries, transportation/shipmentand billing documents
• Experience creating transports wifin teh SAP environment
• Experience in performing Data Profiling on source data using Informatica Data Quality (IDQ) using Informatica Developer. Specialist in using transformations like Expressions, Lookups, Normalizer, XML, Stored Procetcand Informatica S3/Redshift connector/integration experience.
• Flexible, detail-oriented, and comfortable working in a deadline-driven wrok environment
• Strongabilitytoidentifyandresolveissuesindependently,capableofhandlingmultipletaskssimultaneously .
• Primary responsibilities included data analysis and modeling for Pipeline Data Management System consolidation project. Other responsibilities included design and development of SQL server backend for enterprise wide engineering standards testing application, creation, maintenance and administration of a Business Objects universe and various reports for PDMS reporting as well as mapping and extracting legacy data for Pipeline Risk Analysis project.
• Analyzed and solved anomaly detection problem for root-cause events for STB failures. Chose and prototyped ELK stack.
• Experienced in performing in memory data processing for batch, real time, and advanced analytics using Apache Spark (Spark SQL &Spark-Shell).

PROFESSIONAL EXPERIENCE

Senior Associate L2

Confidential

Responsibilities:

• Create detailed documentation as part of data integration technology project, which includes Functional Specification sets (FSD) and Data Integration Mappings to guide ETL team wif technical design documents, and QA (Quality Assurance) test casescreation.
• Identifiedgapsinthebusinessprocessesandworkedwifprojectteamtoenhancetheexistingprocesses.
• Simplified business rules and created data cleansing logics from data profiling teh source data /files. It helped in design of developing data model, mappings, workflows andenvironment.
• Working noledge of report writing wifin SAP
• ExpertiseinDataModelingtechniqueslikestarandsnowflakeschemasusingERWinandSQLDeveloperModelertools. Resolved many to many cardinalities into one-to-many using bridgetables.
• Documented mapping specifications, STM, Unit Test cases, procedure and results and other artifacts. Resolved issues during QA and tuned ETL for better performance at Source, Target, Mapping and Sessionlevels.
• Utilized varied sources, applying business rules and loading them to target Data Marts using Informatica Power Center tool in batch mode solutionenvironment.
• Coordinate wif application team and develop all ETL processes. Assist development teams to maintain all data sources. Proactively identifying, tracking, managing, and resolving software and technicalissues
• Promote Code to UAT and Production using Bamboo and Bit Bucket code managementtool.
• On boarded Adobe marketing and sales data into Azure data lake and on-prem data warehouse, used various python modules&APIstotopulldatafromAdobe,cleansedandloadedintoCloudandon-premDW
• CreatedAlteryxworkflowstoblendandloadthedataintoDataWarehousesforBusinessuserstoquery
• Refactored various stored procedures to optimize queryperformance
• Lead teh production release process including planning, development, testing and communication/ coordination wif otherteams.

Senior Consultant

Confidential

Responsibilities:

• WorkedwifDataModelers&DBAstoensureappropriateDataQualitychecksfordatalineageandmapping
• Worked wif stakeholders to build source to target mapping and meta data framework documents for TEMPeffective data management
• Utilized data mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse. Designed and Developed process documentation to standardize ETL development activitiesforvariousdatasourceslikeOracle,MSSQLServer,XML,JSON,FlatfilesandTeradata
• Secured all teh requirements for ETL work estimations and Unified process of cost estimation for all development work, Implemented and standardized process for ETLteam
• Assisted in creating UAT test scripts and leverage them in UAT testvalidation
• Performing testing for regular SAP release in both Finance and Business Process areas
• Evaluateallfunctionalrequirementsandmapdocumentsandperformtroubleshootonalldevelopmentprocesses
• Involved in raw data analysis for enhancing fraud alert rules and decision systems usingSAS
• Involved in troubleshooting and identifying data discrepancies between data sources, including interpretation and validation of specialized campaigndata

Data Analyst

Confidential, New York, NY

Responsibilities:

• Responsible for preparing teh existing SQL platform for upgrades dat were installed as soon as they were released.
• Assisted in creating and presenting informational reports for management based on SQL data.
• Responsible for maintaining teh integrity of teh SQL database and reporting any issues to teh database architect.
• Created Job parameter sets for reusing teh parameters. Dealt wif XML packs for teh conversion of xml format to tabular data.
• Converted business requirements by developing views and dashboards in Tableau Desktop and publish them to Tableau Server allowing end-users to control data and filter down further as desired.
• Analyzed data from various databases and formatted it into graphs using Tableau Desktop.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Confidence using SAP Interfaces, including creating and using BAPIs (Business Application Programming Interfaces)
• Evaluating and improving existing systems dat are in place as well as collaborating wif teams wifin teh business to integrate these new systems to streamline workflow and company processes.
• Developing and updating technical documentation for senior members of staff and colleagues wifin teh IT department to serve as a reference guide.
• Designing and developing (enhancements and maintenance) new ETL and Business Intelligence Solutions using teh Microsoft SSIS and SQL Server Relational Database technologies.
• Assisting in defining standards for naming, describing, governing, managing, modeling, cleansing, enriching, transforming, moving, storing, searching, and delivering all data wifin teh enterprise.

Senior Analyst

Confidential

Responsibilities:

• Responsibleforassessingcrossimpactsaspartofprojectsupport,whichincludesworkingdirectlywiftheLOBVPsto make recommendations on process changes and define implementationroadmaps
• AnalyzeddatacontainedinthedatabaseusingSQL,AdvancedExcel,andTableautoconfirmdataaccuracyandintegrity of variousreports
• Maintained stability of production environment, testing(QA) and development environment for distributed Data Warehouseapplication
• Experienced in job scheduling using BMC Control-M, Autosys JIL files and IBMTivoli
• Proposed inferences and conclusions, and created dashboards and visualizations of processed data, identify trends & anomalies
• Analyzedrawdataandmetricstobackupassumptionsanddevelopbusinesscasestosolvebusinessproblems
• Designed a data model to incorporate decision support system to identify Data Quality pain area by cleansing and verifying dataintegrity
• Involved in business performance reporting and facilitate team reviews weekly, monthly, andquarterly

Business Intelligence Analyst

Confidential

Responsibilities:

• Designed analytical dashboards and reports which assisted higher management in decision-making strategies & analyzing performancemetrics
• Evaluateallfunctionalrequirementsandmapdocumentsandperformtroubleshootonalldevelopmentprocesses
• Proposed business solution by defining KPIs, designed and developed an automated solution using Tableau; Reduced team effort by75%
• ParticipatedinSCRUMmeetings,involvedinbacklogreviewandSprintplanningsessions,followingAgilemethodology
• Participated in Business, Functional & Internal documentation activities and maintaining teh Requirement Traceability Matrix
• Experience in SAP FICO systems
• Worked wif cross functional teams to develop system reports, use cases and made recommendations for process improvement

TECHNICAL SKILLS

Database Technologies: SQL, Data Modeling, Database Design, ETL, MySQL,SAP, SQL Server 2012, Toad, Redshift

Analytics & Data Visualization: SAS, MS Excel, Tableau, Power BI

Languages & Scripts: Python, R/R Studio, REST/SOAP

Tools & Applications: JIRA, Alteryx, MS Project, Informatica 10, MS Azure.