SUMMARY

• 8 years of IT Experience in the Business Requirements Data Analysis, Application Design, Development, Implementations, and Testing of Business Intelligence solutions using Data Warehousing, Database business systems, ETL, OLAP, Client/Server applications for various domains like Banking, Financial, Insurance Telecom and Health care industry.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification, Big Data, Data Visualization and identifying data mismatch.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources, and scheduling.
• Strong knowledge in implementing Waterfall and Agile (Sprint/Scrum) Methodology.
• Active member in the Scrum team and involved in Scrum planning meetings, estimations and gathered information on requirements.
• Excellent understanding of Data Warehousing Concepts - Star and Snowflake schema, SCD Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.
• Hands on experience on database design, relational integrity constraints, OLAP, OLTP, and normalizations.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling, and Design.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Experience on Master Data Management (MDM) technology, tools to create and maintain consistent and accurate list of Master Data using BI.
• Experience on managing day to day operations forUltiProand PeopleSoft Software including Security, adhoc reports.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Provided Production DBA Support forInformixDatabases as well as troubleshoot incident tickets related toInformixDatabases.
• Experience in Data Modeling using Erwin in Client/Server and distribute applications development.
• Proficient in evaluating modern technologies to provide more efficient and cost-effective solutions for disaster recovery and backup for mission critical systems.
• Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica.
• Experience in designing stunning visualizations usingtableausoftware and publishing and presenting dashboards on web and desktop platforms.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Ab Initio and Informatica Power Center Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers, and packages.
• Created Data Definition Language (DDL), Data Modelling Language (DML), and Transaction queries in SQL.
• Expertise in Testing Complex Business rules by creating mapping and various transformations
• Strong working experience on DSS (Decision Support Systems) applications and Extraction, Transformation, and Load (ETL) of data from Legacy systems and Strong Experience in installation and troubleshooting InformaticaMDM.
• Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000 / 7.0, SQL, PL/SQL (Procedures, packages, functions, database triggers and Teradata).
• Pleasant experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming.
• Designed various reports to provide insight and data visualization using BI/ETL tools like Mainframes SAS, SSAS, SSIS, OLTP, OLAP, Business Objects, Tableau, informatica power center, and Data usage.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Proficient in Performing Unit Testing, Integration System Testing (IST) and User Acceptance Testing(UAT)for data verification.
• Dynamic and assertive team player with a strong inclination to improve and optimize process development and implementation.
• Excellent communication, presentation and written skills, self-starter, quick learner, team player

TECHNICAL SKILLS

Project Methodologies: SDLC, STLC, Waterfall, Agile/Scrum.

Operating Systems: Windows XP, NT/95/2000, Linux 8. X.

Languages: C, PL/SQL, SQL*Plus, JAVA, C++, JSON.

Markup Languages: HTML, CSS, XML.

Database Systems: Oracle 11g, 10i 9i/8i, SQL Server 2008/2005/2000 , IBM DB2, Teradata 12, Sybase ASE 12, MS Access 2007, MongoDB.

Data Modeling Tools: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT, and Dimensions Tables, Conceptual, Logical Data Physical Modeling, Erwin r7.2/3/4, Visio, Sybase Power Designer.

Reporting: Crystal Reports and SQL Server 2000/2005 reporting services.

ETL Tools: Informatica 9.0/8.1/7.x/6.x/5.x, Data Stage, SSIS, SSAS.

Database Development: T-SQL and PL/SQL.

Browsers: Internet Explorer, Mozilla Firefox, Google Chrome.

Operating Systems: Windows 7/8/10, Linux, Ubuntu, Mac OS (IOS7/8/9).

MS Office Tools and other tools: MS Outlook, MS Word, MS Excel, MS PowerPoint, MS Access, Microsoft Project, MS One Note.

PROFESSIONAL EXPERIENCE

Confidential, Denver, Colorado

Sr. Data Analyst

Responsibilities:

• Meet with customers to determine their needs, gather, and document requirements, communicate with customers throughout the development project to manage customer expectations, resolve issues, and provide project status.
• Written documentation to describe program development, logic, coding, testing, changes, and corrections.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Worked onDataIntegrationfrom different source systems.
• Created, configured management reports and dashboards in Splunk for Application Log Monitoring and supported Splunkcluster infrastructure in AWS cloud environment.
• 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
• Worked with data investigation, discovery, and mapping tools to scan every single data record from many sources.
• Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.
• Troubleshoot test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models and worked in Enterprise Resource Planning(ERP).
• Informixserver's tuning parameters to reduce disk contention. The first pass reduced a load job from an all-night procedure to aone-hour job.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Worked with Spark Context, Spark-SQL, Pair RDD's, Spark YARN.
• Implemented Data blending, Replace references, Customized queries and advanced visualizations inTableau.
• Designed ETL (Informatica) Architecture & Processes to support enterprise wideData warehouse.
• Developed fully automatedSASbased infrastructure to support campaign execution for new digital marketing channels.
• Extensively used Stored Procedures, Functions, Triggers and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations
• Developed structured, efficient and error free codes forBigDatarequirements using my knowledge in Hadoop and its Eco-system.
• Optimized the SQL and PL/SQL queries by using different tuning techniques like using hints, parallel processing, and optimization rules.
• Responsible for SQL tuning and optimization using Analyze, Explain plan and optimizer hints.
• Data Mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Developed the strategy, operating model and assurance framework to assess and monitor the maturity and implementation ofdatagovernanceactivities in the organization.
• Volume Manager (LVM) and tuning of kernel parameters. Also installedInformixIDS 11.70 database server.
• Responsible for performing the data validation, process flow, dependency, Functionality Testing, and User Acceptance Testing.
• Database recovery and subsequent problem resolution.

Environment: TableauServer,TableauDesktop, Informatica9.x, Business Objects XIR3.1, Web I, Universe Designer, SQL Teradata 13.10, Oracle 8i/9i, PL/SQL, Windows XP.

Confidential, Philadelphia, PA

Sr. Data Analyst

Responsibilities:

• Gathered & identified businessdatarequirements from business partners and development teams, understand the information needs and translate thosedatarequirements into conceptual, logical, and physical database models.
• Created Conceptual, Logical, and Physicaldatamodels as per enterprise standard and designed the Logical Model into Dimensional Model using Star Schema and Snowflake Schema on Erwin to builddatawarehouse
• Responsible to play a key role in day-to-day support of Business Intelligence tools, Decisional and Reporting solutions, Business Objects, and underlying ETL framework.
• Responsible to createDataStage jobs to extract transform and loaddatainto VLDBdatawarehouses from various sources like relational databases, application systems, temporary tables, flat files etc.
• Preparing Dashboards using calculations, parameters inTableau.
• BigDataPOC Development on AWS-Amazon Web services/Cloudera. Creating and modifying Business Intelligence analytical reports usingTableau.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Performed numerousdatapulling requests using SQL for analysis and Build monitoring solution(s) for theBigDatainfrastructure to understand the health of the infrastructure.
• Developed a method to back up theInformixdatabase to (and recover from) a single file system. The backup now completes
• Wrote hundreds of DDL scripts to create tables and views in the companyDataWarehouse.
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts.
• Designed and developed Ad-hoc reports as per businessanalyst, operationanalyst, and project managerdatarequests
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Developed reports using the Teradata advanced techniques like rank, row number etc.
• Worked onDataVerifications and Validations to evaluate thedatagenerated according to the requirements is appropriate and consistent.
• Developed T-SQL Scripts and SSIS packages for loading theData Warehousedimension and fact tables on a daily and incremental basis and Implemented a simulated lock-quota monitor, providing a feature not yet provided by theInformix software.
• Daily activities involveddatapreparation, extraction, manipulation anddataanalysis usingSAS and Well versed withInformix4 GL/InformixSQL development environment.
• Performed Sorting and Merging ofdataand generated tables, and graphs usingSAS/Base,SAS/Stat andSAS/Graph,SAS/SQL.
• Preparing Dashboards using calculations, parameters inTableauand DevelopingTableaureports that provide clear visualizations of various industry-specific KPIs.
• Extracteddatafrom existingdatasource, Developing and executing departmental reports for performance and response purpose by using oracle SQL, MS Excel.
• Published severalInformixutility scripts to the IIUG software library, written in Korn Shell, AWK, and C.
• Work with IT quality assurance and software delivery teams regarding code tuning efforts, project phase, post-implementation phase, and performance analysis, as matters are observed in the production environment

Environment: TableauServer,TableauDesktop, UNIX scripting, Oracle SQL Developer, Teradata 13, Windows XP, SASdatasets, HP ALM, MS Office Suite (Word, Excel, Access, and Power point).

Confidential, San Diego, CA

Data Analyst

Responsibilities:

• Designing Logical and Physical data models for collateral management application.
• Working with the Business and Development team members and the Data Architect of the various components.
• Worked with project teams to collect database requirements and scope them to create logical data model.
• Developed data quality rules for the application and ETL team to cleanse and transform the data.
• Facilitated JAD sessions for data requirements.
• Extensively used ERwin for developing data model using star schema methodologies.
• Involved in Data migration of legacy customer accounts, products data into the new collateral management application.
• Worked in the Data migration approach of loading into target on incremental approach.
• Designed staging tables for Data migration to load and transform legacy data.
• Importeddatafrom Excel, Word and text-baseddatafiles intoSASdatasets. Wrote edit checks to remove invaliddata.
• Involved in buildingBigDatacluster and successfully performed installation of CHD using Cloudera manager.
• Manage and organizedataintegrationproject tasks and meet deliverables associated with the design, configuration and deployment of business tools and procedures.
• Involved in creating custom hierarchies to meet the business requirement inTableau.
• Worked with users and DBA to grant user access.
• Involved in develop, format, complex reusable formula reports and reports withTableau.
• Developed integrated MDM solutions for operational efficiency and data quality standards for customer, product and locations.
• Running/Monitoring/Restoring differentBSScustomer nodes on requests and Worked on Integration ofBigdataand cloud platforms Using Talend.
• Developed programs using BaseSAS&SAS/Macros to extractdatafrom oracle tables.
• Creating the data requirements for the shared program data stores and generate the Necessary DDLs for creating the database objects (tables, views, stored procedures, triggers)
• Worked on source to target mapping between legacy and target data model
• Work with offshore team to handle data warehouse, ETL and Business Intelligent development.
• Audit of Payments system, OFAC & Sanctions, hits and mitigation process. Investigation and reporting.AML, Fraud related hits, investigations and in case of suspicious activityBSAInvestigation opened and the process is initiated and based on the results either case is closed or SAR is created & filed in a timely manner
• DevelopedOSS/BSSsoftware system modules such as; CRM, Order Management, Warehouse Management, Trouble Ticket Management, Network Inventory and Circuit Design, and IP Management.
• Created and updated metadata in the data model repository.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.Worked in the development of end to end data flows for the application
• Worked on Design, report and layout with Reporting team
• Developed Quality Assurance plans as data cleansing and data quality rules.
• Worked in the validation of test data and data conditioning to support the testing.
• Proficient in data governance team to establish new processes and procedures like data standardization and data quality
• Hands on experience on quality Center tool for defect tracking and resolution
• Worked in evaluating and implementing tool sets for data profiling
• Worked with data conditioning and test cases for supporting testing phase

Environment: Oracle 11g, PL SQL Erwin, INFORMATICA 8.6.1, MSSQL Server 2005, IDE, IDQ, DB2, Business Objects, TOAD.

Confidential

Data Analyst

Responsibilities:

• Involved in gathering user requirements along with the Business Analyst. Part of the team responsible for the analysis, design, and implementation of the business solution
• Involved in planning of development work using Agile Software Development.
• Gathered Business requirements from the stakeholders, SME's and documented the requirements in the BRD.
• Developed FRD (Functional requirement Document) for dataarchitecture and communicated with the SME's.
• Designed Mapping document, which is a guideline to ETL Coding.
• Created artifacts such as Use Cases, Activity Diagrams, Swim lanes Diagrams and Sequence Diagrams using UML/Visio.
• Optimizeddataintegrationplatform to provide optimal performance under increasingdatavolumes.
• Experience in operational support and hands-on implementation Hadoop basedBigDataPlatforms. Gathers requirements, builds logical models and provides quality documentation of detailed user requirements for the design and development of systems.
• Created source to target mappings with transformation rules.
• DevelopedTableaudata visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Createddataset reports for users by writing SQL queries which then were used for UAT.
• Documented the process flow to describe program development, logic, testing, and implementation, application integration, coding.

Environment: Scrum and Waterfall Methodologies, Rally software, JIRA, MS Visio, MS Excel, Oracle database, UNIX & SQL Database Server, Rational Rose

Confidential

Data Analyst

Responsibilities:

• Involved in gathering user requirements along with the Business Analyst. Part of the team responsible for the analysis, design, and implementation of the business solutions
• Communicated with business Users to identify needs, define project scope, and detail functional and non-functional requirements
• Gathered and analyzed business requirements by facilitating JAR/JAD Sessions.
• Successfully used MS Visio Analysis model, gathered requirements, facilitating use case workshops in sessions.
• Reviewed documents/templates and identified gaps and suggested changes to Quality Assurance team.
• Involved in developing Test plan and Test cases based on Use cases and Functional Specifications.
• Created test cases for FRD to perform Integration tests and verify the integrity of the accounts built on FRD.
• Performed backend testing to check the system dataintegrity for insert, update, delete and retrieve transactions by being involved in writing complex SQL queries including joins, group by, having clause etc.
• Involved in preparing Dataflow diagrams for the decision logic using MS Visio tool.
• Co-ordinated with QA team to test and validate the reporting system and itsdata.
• Provideddataintegrationscheduling, exception management, event notification and ETL operational reporting and audit services.
• Verify information received is entered correctly to ensure prompt enforcement ofchildsupport.
• Work with DBAs to create Physical Data models and other database enhancements by providing scripts and validations.
• Documenteddataquality and traceability documents for each source interface
• Documented, clarified, and communicated change requests with the requestor and coordinated with the development and testing team

Environment: Oracle 10g/11g, PL/SQL, SQL Server 2005, Toad, UNIX, UML