Experience

Celink

• United States
• Financial Services
• 100 - 200 Employee

• Business Systems Analyst

  • Oct 2019 - Present

  − Expertise in Framework Manager Modeling Physical Layer, Business Layer, Packages and Complex Reports developed in Report Studio and Query Studio and Analysis Studio. − Modeled new data models based on user requirements and updating existing data model. Created new metadata and updating existing metadata. − Preparation of Report Mapping documents, Source to Target Mapping documents (STM) and for loading the data to Target tables. − Performed detailed attribute analysis. − Conducted data model reviews with project team members. − Communicated with stakeholders to define business strategy to create centralized reporting capability for analytical and ad hoc reporting; wrote requirements specification documents and designed report mockups. − Researching critical help desk tickets for development, researching trying to reproduce the defect raised and documenting them as an enhancement as needed. − Resolving the queries regarding system related functionalities of business users/clients. − Create and maintain technical documentation for Data Warehouse ETL processes and Business Intelligence reporting tools − Performs more complex quantitative and qualitative analysis for business processes and/or projects. Often manages small projects, business processes or parts of larger ones. − Environment: DB2, Talend (ETL), MS Visio, Erwin, IBM Cognos, Windows, Linux, Agile/Scrum methodology.



ACS Solutions

• United States
• Information Technology & Services
• 700 & Above Employee

• IT Analyst

  • Jul 2016 - May 2019

  - Involved in reporting requests (ad-hoc and scheduled) from key systems like Ceridian (Payroll system), HGC (Compliance system), bullhorn (ATS system) as per the business requirements. - Worked on Oracle Data Modeler/MS Visio for mapping both user-defined and default data types and creating Database Design (Physical and logical) for CAP(Consultant assignment portal -Onboarding portal), ODS etc. - Being an SME of multiple systems, act as a first level reviewer/testing data for testing certain features, workflows as needed.Completion of user stories in an agile software development environment. - Acted as a liaison between client/user and the development team walking through few requirements by preparing artifacts (technical/business rules, mapping documents etc.) which will aid in development process across multiple systems. - Analyzes the ETL code to extract data mapping details and upload to metadata management tool to establish data lineage traceability. - Employs techniques to create data and reporting requirements .Engages in data profiling activities to identify any data quality issues. - Worked in all phases of the life cycle including analysis, design, development, testing, deployment, post-production maintenance, documentation and training. - Acted as a data steward for ODS (Operational Data Store) worked on maintaining a repository for users, static data and updated views accordingly in ODS and syncing up across different applications. Involved in developing talend job for the static services in projects as part of the drop-down list of values. - Involved in key migration activity of integrating and migrating multiple sources of data into one system (use of sql and ETL). - General knowledge and involvement in building of Master ODS(operational data store) and/or Enterprise Information Management. - Mastered the ability to design and deploy rich graphic visualizations using drill down and drop down menu option and parameters using Tableau.



Equifax

• United States
• Financial Services
• 700 & Above Employee

• Data analyst

  • Aug 2015 - Jun 2016

  • Primary responsibilities include Data extraction and Data analysis for the application Affordable care Act (ACA) Product. • Extracting data from multiple operational sources, transforming, cleansing, and filtering the data, and finally loading the data into one or more target databases. • Process individual client configurations in web based application to track labor hours, determine benefits eligibility, and alert client to potential compliance risks and penalties under the ACA. • Loading master and reference data, and transaction data into normalized tables. And loading the fact, dimension and bridge tables in a dimensional model. • Advanced creation of complex SQL queries, and stored procedures in order to validate data imports, diagnose issues, and produce analytics for client feedback. • Worked to create test plans, project plans and test scenarios. Developed complex SQL queries to query data. • Developing batch files to load test files and automate the scheduling process. • Involved in Data mapping, Column mapping and maintain data dictionaries and Data models. • Involved in Knowledge Transfer to the peers, Documenting of all the Business logic insuring maintenance is easy for the Peers and Responsible for conducting code reviews in my team. Environment: Oracle 11i, PL/SQL Developer, T-SQL, SSMS 2008,Toad, eThority, UNIX, Shell Scripts, Windows, Linux.



New Edge Group

• Greater Atlanta Area

• Oracle Developer Intern

  • Feb 2015 - Aug 2015

  Responsibilities: • Worked on Erwin Data Modeler for mapping both user-defined and default data types and creating Database Design (Physical and logical) as per the requirement given by business • Developed PL/SQL packages, procedures, functions, materialized views, SQL Scripts and triggers to populate the historic data in the tables applying business logic • Worked on sequences, functions, synonyms, indexes, triggers, packages, and stored procedures. • Involved in Creation of tables, Partitioning tables, Join conditions, correlated sub queries, and nested queries, views for the business application development. • Created temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables. • Wrote Materialized views and complicated queries using SQL. • Involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming. • Used the advanced features of PL/SQL like collections, nested table, array & Dynamic SQL. • Wrote SQL sub-queries with join conditions and PL/SQL scripts • Involved in performance tuning of SQL queries and Created indexes on tables and optimizing Stored procedure queries • Design and developed the scripts to create table, views, indexes and sequence. • Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries. • Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance. Environment: Oracle 10g, SQL* Plus, SQL * Loader, ODI, TOAD, Erwin, UNIX.



Infosys

• India
• IT Services and IT Consulting
• 700 & Above Employee

• Oracle Developer

  • Jan 2013 - Jul 2013

  Responsibilities: • Created database objects like tables, sequences and constraints as per the business requirements. • Extracted data from the source views by writing the procedures to load the data into staging tables. • Created database views and materialized views and database triggers based on requirements. • Developed stored functions, packages based on requirement. • Automated quality check tasks by creating pl/sql procedures, cursors, functions and dynamic sql. Enhanced it with creating exceptions for error handling. • Involved in creating logical and physical data modeling using Erwin. • Modified and debugged several pl/sql programs for performance tuning using techniques like explain plan and dbms_profiler • Written complex oracle sql queries with complexity using inner/outer joins, union all, intersect& minus set operators • Created indexes on tables and optimized procedure queries. • Maintained database security by authenticating users, using logon triggers. • Running explain plan for tuning the sql queries. • Used exception handling extensively for the ease of debugging and displaying the error messages in the application • Created test scripts documentation for all the procedures that I have created. • Maintained data guard to ensure high availability, data protection and disaster recovery for enterprise data. • Involved in production support, like monitoring the performance of the Unix jobs. Environment: Oracle 11g, SQL*Plus, PL/SQL Developer, Data Guard, Toad, SQL * Loader, UNIX, Shell Scripts, Erwin, Windows, Linux.