SUMMARY:

• More than 10 + years of experience as an Technical Business Analyst/Data Analyst in Data warehousing, Insurance domain, Big data hadoop, Business Intelligence (BI) Solutions design & development.
• 4+ years of experience working as a Functional, Data or Business Analyst.
• Experience in Access, Excel(Advanced), Visio, and MS Project.
• 4+ years of customer interfacing experience - project oversight, customer presentation.
• 4+ years SQL Server 2005/2008 knowledge - T-SQL, Oracle, Vertica, Terradata, Hive, HDFS Tables, Views.
• Experience in integration between business and technology, performs feasibility analysis, scopes projects, and works with the project management team to prioritize deliverables and negotiate on product functionalities
• Experience in Informatica, Amazon S3, Vertica, Terradata and Redshift
• Experience using Talend component for Data Integration, Data Mapper, Big Data and Data Quality.
• Experience in Talend Installation, configuration and administration
• Experience with job scheduling using TAC and Job Conductor
• Experienced in data integration, metadata management, ETL, data modeling tool sets.
• Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, Perl 5.0, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1 and Visio 10.0.
• Installed, Configured OBIEE 11g and Migrated OBIEE 10G to 11G.
• Data modelling and oracle performance optimization
• Experience in Cloudera 5.2 platform and Hands-on experience in Hive, PIG, Spark, Hbase
• Experience in core java programming.
• Business Intelligence area dealing with data analysis, solution design metadata management and MDM.

PROFESSIONAL EXPERIENCE:

Confidential, Southlake, TX

Technical Business/Data Analyst

Responsibilities:

• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Performs feasibility analysis, scopes projects, and works with the project management team to prioritizes deliverables, and negotiate on product functionalities.
• Creates detailed Business Requirement Document (BRD) and translate it into functional specifications.
• Provides analytic support by coordinating data extraction from various databases and data interpretation.
• Partners with development and analytic teams to provide reporting on software solutions.
• Participates in Integration Testing and User Acceptance Testing (UAT) and Functionality Testing.
• Utilize issue tracking system (JIRA) daily.
• Provide feedback to the clients and technology managers.
• Generate routine and ad-hoc reporting and analysis to assist in evaluating production performance and resolving issues

Confidential, Nashville, TN

BI Data Analyst

Responsibilities:

• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Organize and facilitate requirements elicitation, business process analysis and review meetings with business users and stakeholders of information systems being developed
• Document in detail system processes in diagrammatic and textual format
• Assess overall project requirements, business needs, pain points, and areas of process improvement
• Create and maintain requirements documentation for information systems being developed, including business analysis models, functional specs, use-case models and use cases
• Use software tools for maintaining repositories of requirements documentation
• Gain an understanding of existing systems' functionality, compare current/envisioned business processes to system functionality, and document gaps
• Participate substantively in testing the functionality of systems being developed to determine whether requirements captured and approved are being met
• Design and Implemented ETL for data load from heterogeneous Sources to SQL Server and Oracle as target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.
• Design talend job using sqoop, file list, Hive Hadoop ecosystem components.
• Used Bigdata components tImpalaInput, tImpalaRow, tHDFSConnection, tHiveConnection,tHiveLoad, VerticaOutput etc..HDFS file system and vice versa.
• Implemented Data loads from talend server to HDFS file system.

Confidential, Brentwood, TN

Business/Data Analyst

Responsibilities:

• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Design Metadat using Metadata management frame work
• Creating, designing and formatting requirement specification documentation, including architecture diagrams, process flows and other information or processes needed to describe required system changes for development.
• Assessing business operations and processes of business units to understand procedures, information flows and handoffs, decisions, communications pathways and more.
• Participating in meetings and projects with client staff, project managers and developers to automate, upgrade and expand mission critical applications.
• Assisting in the UAT testing phase, including test strategy development, test case creation, test script development, test execution, defect tracking and reporting.
• Developing queries, analyses or reports from applications for operations or management staff.
• Implemented Variables and Parameters in the mappings.
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components
• Created and managed Source to Target mapping documents for all Facts and Dimension tables
• Used ETL methodologies and best practices to create Talend ETL jobs.

Confidential, Carmel, IN

Data Analyst

Responsibilities:

• Define downstream targets for MDM with design for attributes and sync methodologies.
• Worked on agile software methodology that resulted in enhanced productivity and produced high quality software.
• Used Metadata management frame work integrate and manage metadata
• Implemented Metadata Management framework to captures, manage and publishes rich metadata.
• Worked on the design, development and testing of Informatica mappings.
• Involved in Talend Big data requirement gathering and design analysis.
• Configuration of big data platform, tools with limited help from admin
• Loading data from disparate non-Hadoop sources which can be both structured and unstructured
• Logical and Physical data model design.
• Provide integration support to DataStage teams for downstream integration.
• IBM Initiate broker configuration for data sync with sources and message processing based on source priority.
• Worked on the high-level design using design patterns and Object Oriented programming and OOAD concepts.
• Created ETL job infrastructure using Talend Open Studio
• Custom Code Design for integration to downstream ODS and Data Warehouse for BI needs.
• Configure Spring Batch framework for moving legacy data to new platform
• Recommendation of MDM Best Practices in overall strategy.
• New Composite Services Design for lookup and update services in MDM Server and troubleshooting MDM response.

Confidential, New York City, NY

Data Analyst

Responsibilities:

• Led DW/BI best practices sessions and suggested design changes to processing/querying bottlenecks.
• Worked on Informatica ETL Mappings, exceptions handling, compliance tracking and data reconciliation.
• Architected MDM solution for customer information across various source systems
• Delivered MDM stewardship and data governance program.
• Collected and studied the Metadata about the master data for MDM and the transactional data.
• Worked on Talend to load Data from various sources like to Oracle DB
• Involved in Requirement Analysis and Use Case development using rational tools, OOAD and RUP.
• Created ETL test data and tested all ETL mapping rules to the functionality of the Informatica mapping.
• Create Conceptual and Physical Data Models for the source system using Erwin 7.3.
• Tailored product for each client providing customisations in data warehouse, ETL mappings, OBIEE Answers, Dashboards & BI Publisher.
• In utilizing Business Intelligence tools for the design and deployment of Data Marts supporting Enterprise Data Warehouses.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Performed bulk data load from multiple data sources and Flat files to Teradata RDBMS using BTEQ, Multiload, FastLoad and UNIX shell scripting.
• Worked closely with Testing team and helped in testing the Informatica mappings, workflows, AbInitio Graphs and Teradata scripts
• Providing Data Quality support in the process of migration of the fact and dimension tables from Oracle to Netezza platform.

Confidential, Hartford, CT

ETL Developer

Responsibilities:

• Serve as owner Applications List (AITs) utilized for prioritizing, managing, tracking and coordinating ALDM activities.
• Support the development and maintenance of Data Management education and assessment materials for use in driving awareness and compliance to the Enterprise Data Management Standards.
• Continue development and maintenance of SharePoint site and SQL database for coordinating ALDM Curriculum, capturing assessment results, tracking progress, and managing overall metric reporting.
• Lead team with regards to conducting data analysis in support of application prioritization, developing and maintaining macros for assessments and pulling data as needed for application audits.
• Support other team members as they manage and lead engagements with assigned Application Teams to provide guidance and support through the execution and collection of evidence demonstrating EDM compliance.
• Complete process documentation, procedures and adoption related materials as necessary.
• Creation of database objects like Tables, Views, Procedures, Functions, Triggers, Packages using Oracle tools like SQL* Plus and PL/SQL
• Responsible for creation of database in ORACLE and maintaining the database
• Developed various complex stored procedures, Functions, packages, and triggers in PL/SQL
• Wrote various SQL* Loader scripts to load data into oracle database and extensively used SQL scripts to validate the integrity of data
• Extensively used database triggers for adding various default functionality, like Database & non-database methods of running totals, sequence generation
• Worked with DBA in writing complex stored Procedures, Functions, Packages and triggers in PL/SQL as well as Shell scripting
• Wrote Perl Scripts for creating batch executable scripts.
• Wrote SQL statements, SQL Query tuning, views, cursors, schemas
• Monitoring the databases and optimizing database performance and use of resources, including selecting optimal physical implementations of databases. Maintaining availability and integrity of databases, including referential integrity checking and multiple access schemes and Database capacity planning
• Worked with the Java Developer to write PL/SQL procedure as per the requirement
• Helped with Data Mapping between the data mart and the Source Systems.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.

Confidential

Programmer Analyst

Responsibilities:

• Interacted with Business Users to conduct thorough Requirements Analysis.
• Created and scheduled Sessions based on demand, run on time and run only once using Informatica Server Manager.
• Design Java User Interface for the Account entity where the users login and browse the account details.
• Creation of database objects like Tables, Views, Procedures, Functions, Triggers, Packages using Oracle tools like SQL* Plus and PL/SQL
• Responsible for creation of database in ORACLE and maintaining the database
• Developed various complex stored procedures, Functions, packages, and triggers in PL/SQL
• Wrote various SQL* Loader scripts to load data into oracle database and extensively used SQL scripts to validate the integrity of data
• Extensively used database triggers for adding various default functionality, like Database & non-database methods of running totals, sequence generation
• Worked with DBA in writing complex stored Procedures, Functions, Packages and triggers in PL/SQL as well as Shell scripting
• Wrote Perl Scripts for creating batch executable scripts.
• Wrote SQL statements, SQL Query tuning, views, cursors, schemas
• Monitoring the databases and optimizing database performance and use of resources, including selecting optimal physical implementations of databases. Maintaining availability and integrity of databases, including referential integrity checking and multiple access schemes and Database capacity planning
• Worked with the Java Developer to write PL/SQL procedure as per the requirement
• Performed backed testing using SQL queries and analyzed the server performance on UNIX.
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.