Resume

Sign in

Informatica Ssis

Location:
United States
Posted:
April 28, 2021

Contact this candidate

Resume:

Sharifa Sanjamala

PL/SQL developer

Email: adl0t8@r.postjobfree.com

Phone: +1-248-***-****

Experience Summary

Over 8+ years of professional work experience in analysis, design, development and support in Telecom, Banking and Health care domains using SQL, PL/SQL, Oracle, Unix Scripts, Java, XML and ETL technologies

Experience in solution Designing, development and SME (subject matter expertise) for application support of PL/SQL applications (Telecom domain) in Oracle.

Extensive experience in using T-SQL (DML, DDL) in SQL Server 2016/2012/2008 platforms.

Experience on writing Dynamic SQL, SQL, Complex Stored procedures, functions, Triggers, views, and indexes.

Good Experience in Test Driven Development (TDD), Debugging, Bug tracking, Application performance, System analysis and design and good in Problem solving techniques.

Extensive knowledge on Java stack and Spring frameworks

Experienced in working directly with clients to define requirements and specifications, project work planning and management, design, development and successful implementation of applications and systems.

Experience in Query Optimization and performance tuning using SQL Server Profiler for SQL and stored procedures, functions etc.

Strong Understanding of Agile methodology and its concepts.

Experience in creating Drill-through and Drill-down report, and different kind of reports such as Sub Reports, Charts, Matrix Reports, Linked Reports, and List, Tables, Slicers using SSRS.

Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.

Used SQL Server Migration Assistant for data Migration from different Sources like Oracle, MS Access, DB2.

Hands on experience in developing Dimensions, KPI’s, Calculated Columns, Hierarches and processing Cubes using SSAS.

Excellent communication and interpersonal skills and build strong business relationships with customers, users, and Clients.

Goal oriented - known for delivering within deadlines with least amount of rework.

Highly Committed, Enthusiastic, Creative team player.

Technical Skills

Programming Languages

SQL, T-SQL, PL/SQL, UNIX Shell scripting, Java, XML.

Environment/Tools

Oracle 11g, Informatica (ETL tool), SQL Server R2/2012,2015 SSIS, SSRS, SQL Server Management Studio, putty, MS Visual Studio 2010, Import/Export Wizard, Informatica power center, Amdocs Clarify bridge CRM, Hermes, Tera Data, TOAD.

Operating Systems

Windows server, Unix.

Projects:

Client

Express Scripts

Role

PL/SQL developer

Location(s)

Franklin Lanes, New Jersey

Duration

Jan 2020 to present

Environment/ Tools

MS SQL Server DTS, Windows Server 2008, SSMS, SSRS, Crystal Reports, SSIS, SSRS, T-SQL, UNIX, XML, Report builder 3.0, Informatica, Teradata.

Roles and Responsibilities:

Developed complex programs in PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.

Rewrote SQL queries to upgrade SQL Server performance using SQL Server.

Extensively worked on stored procedures, triggers, Views, cursors, T-SQL scripts, schemas.

Uploaded reports on to the report manager and organized them into folders.

Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping etc.

Expertise in blending the existence specifications into new system using SSRS.

Responsible for scheduling the subscription reports with the subscription report wizard.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.

Experience of ETL processes and procedures, including data mapping, conversion, staging, scrubbing.

Designed and developed SSIS Packages to extract data from various data sources such as Access database,

Excel spreadsheet, and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all.

Ability to troubleshoot, debug and make stored procedures, UDF’s, views and other database objects fully functional in 2012 environment.

Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts, and processes.

Created Linked Servers to connect OLE DB data sources and providers.

Administered the SQL server by creating user logins, dropping, and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.

Client

Equifax

Role

SQL developer

Location(s)

Alpharetta, Georgia

Duration

Apr 2019 to Dec 2019

Environment/ Tools

Oracle, SQL, Pl/SQL, T-SQL, TOAD, UNIX, XML.

Roles and Responsibilities:

•Created complex Store Procedures and tables to load the data on Incremental load logic.

•Created an SSIS Package for reading multiple excel files from the source and added validation before loading into destination tables.

•Created an SSIS Package which can load multiple sheets in an excel workbook dynamically.

•Performed an end-to-end testing of the data in TEST and Production databases after loading the data.

•Created a store procedure which will validate the results and flags it up at the end.

•Designed Star schema (identification of facts, measures, and dimensions) and Snowflake schema.

•Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analysing purpose.

•Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

•Configured replication servers and transactional replication between production & standby server for disaster recovery.

•Worked with XML Files in generating reports using SSRS.

•Experience in creating multiple reports in Drill mode using tables, financial tables.

•Used Toad for retrieving information from database.

Client

Deutsche Bank

Role

ETL developer

Location(s)

Brooklyn, New York

Duration

Jan 2018 to Mar 2019

Environment/ Tools

Informatica power center, Pl/SQL, Oracle, Unix shell scripting, XML.

Roles and Responsibilities:

Developed Informatica mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.

Worked on various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Centre Designer.

Designed and developed various PL/SQL stored procedures to perform various calculations related to fact measures.

Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.

Ability in using web service for Online Data transformation.

Analyse and understand the Technical Specification Document (Source to Target matrix) for all mappings and clarify the issues with Data Architects.

Provided few enhancements to the existing ETLs as per the requirement.

Worked on enhancements of the mappings and workflows as per the changes defined by the user.

Extensively used ETL to load data from Oracle database, xml, flat files to different target systems.

Debugging and fixing jobs in case of job failures.

Performed requirement gathering from client side and deadlines of different phases/waves involved.

Used crontab /PowerCenter, Autosys for scheduling jobs.

Worked on performance tuning for the sessions/workflows under different conditions and applying the best suitable method.

Client

United Health Group

Role

SQL developer

Location(s)

Lansing, Michigan

Duration

Jan 2017 to Dec 2017

Environment/ Tools

Oracle, SQL, Pl/SQL, T-SQL, TOAD, UNIX, XML.

Roles and Responsibilities:

Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).

Create Database Objects like tables, views, sequences, synonyms, stored procedures, functions, triggers as per the business requirements.

Wrote UNIX Shell scripts as per the business requirement.

Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and extensive usage of Indexes.

Read data from flat files and load into Database using SQL*loader.

For increasing the performance of all the collection based DML used FORALL and scanned the collection using FIRST, LAST and NEXT in loops.

Involved in modifying various existing packages, procedures, functions, triggers According to the new business needs.

Writing complex queries using multiple tables.

Scrutiny and developing the business validation constraints.

Design procedure for administrative module for data collection, deletion and Updating with functional requirements in child validation and verification relations.

Design user defined integrity triggers to maintain the security and validity of data between users.

Involved in explain plan for query optimization.

Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts, and processes.

Client

British Telecom

Role

Software Engineer

Location(s)

Bangalore, India

Duration

May 2014 to May 2016

Environment/ Tools

Oracle, SQL, PL/SQL, Web Servers, UNIX, JMX, Putty, XML, Hermes, TOAD.

Roles and Responsibilities:

Analyze the issues through logs, find the root cause (RCA) and resolving the issues (Bridge Cases) within SLA (Service Level agreement), and if required raise it to 3rd line support for bug fix.

Created Stored Procedures, User Defined Functions, and Triggers to work consistently with the dynamic databases.

Wrote and maintained database documentation, including data standards, procedures, definitions for data dictionary and logical and physical models of the database.

Involved in Deployment activities according to the release on the platform.

Perform AIS activities (DR activity, checking of builds details) for every release.

Perform Change management activities like raising new CRs, identifying the risks of other component CRs and accordingly providing the approvals.

Adhere to the Quality standards, Monitor the system, escalate immediately when issue arises.

Effective and clear communication during the incidents.

Ensure 100% compliance with SLA targets.

Ensure the reduction in cycle time through automation, innovation, refactoring.

Helping new resources to understand the project work.

Generation of daily reports consisting database health and statistics related information.

Involved in interacting with businesspeople on daily basis for better understanding and implementation.

Client

British Telecom

Role

Technical Associate

Location(s)

Pune, India

Duration

July 2012 to April 2014

Environment/ Tools

SQL Server 2008/2005 Enterprise Edition, PL/SQL, Web Servers, UNIX, JMX, Putty, Amdocs Bridge Clarify CRM tool.

Roles and Responsibilities:

Expertise in OSS Service fulfillment (Service provisioning and activations), Fault management.

Involved as team member in solving the incidents through CRM tool.

Generate Job & scheduled reports from cronjob.

Involved in transition and war gaming of code red project from another vendor.

Responsible for performing data investigation to assess problems associated with the application.

Providing Application, technical support for critical software releases and LIVE deployments.

Handled high level client escalations.

Proactively monitoring the system & system processes/logs for any failures.

Root cause identification and resolving the issues (Bridge Cases) within SLA.

Bridge Case Handling P1, P2, P3 rating issues with tightens SLA agreement of Client.

Education:

Master of computer Applications from SV University Tirupati, AP, India.

Bachelor of Science from SV University Tirupati, AP, India.



Contact this candidate