We provide IT Staff Augmentation Services!

Ps Consultant Resume

2.00/5 (Submit Your Rating)

OBJECTIVE:

To be associated with a progressive and professional organization with challenging and responsible opportunity to utilize my strength and skills towards organization and personal growth

SUMMARY:

  • Experience in Analyze and define clients’ business strategy and determine system architecture requirements to achieve business goals.
  • Formulated strategic plans for component development to sustain future project objectives.
  • Analyzed the current state innovation, product development and manufacturing operating model, including organizational constructs, business processes, systems, information and data
  • Developed recommendations and the associated business case to reduce product costs and increase overall speed and efficiency
  • Drive the complete application and process lifecycle from inception to the end of life
  • Analyze, design and implement new/improved operational capabilities in master data architecture
  • Facilitated workshops to define requirements and develop solution designs
  • Developed and execute work plans and deliver stream(s) of work (e.g., testing, training)
  • Work with an on/offshore development team to design, build, and test software solutions in a regulated environment.
  • Provides solutions to complex business problems for area(s) of responsibility where analysis of situations requires an in - depth knowledge of organizational objectives.
  • Day to day management of the Agile system
  • Gather detailed business requirements and use cases, and translate technical specifications into product requirements.
  • Created team strategies and establish project scopes of work; communicate project deliverable timeframes and benchmarks to customer
  • Having sound technical knowledge and domain expertise in Finance, aviation, Banking
  • Participated as a key team member for the supporting and maintenance of Services CRM solutions, Global data warehouses and analysis and reporting applications for the Asia Pacific regions
  • Strong experience in Design, Development, Implementation, Administration, Troubleshooting and support of ETL & BI process using Microsoft, Confidential, SAS technologies
  • Extensive experience in designing, developing and Implementing Extraction, Transformation and Load techniques on multiple database platforms and operating system environments
  • Experience in implementation of data cleanup procedure, transformations, scripts and execution of test plan for loading the data successfully into the target
  • Experience in Performance Tuning, Identifying and resolving performance bottlenecks on various levels like sources, targets, mapping
  • Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem solving skills to undertake challenging jobs. Able to work well independently and in a team by helping to troubleshoot technology and business related problems
  • Well versed in MS-OFFICE tools

TECHNICAL PROFICIENCY:

Operating Systems: Windows NT/XP/7/10, Windows 2003 Server, Linux

RDBMS: SQL Server 00/05/08/12, MS Access 07, Confidential 13/14/15, Oracle 10/11G

ETL Tools: SSIS 05/08/12, DTS 2000, Talend,TPT,btq,SAS DI,Data mover, QueryGrid

BI Tools and Utilities: SSRS 00/05/08, SSAS 2005, Crystal Reports, QlikView 7.2, LogiXML 8.1, Cognos Reportnet, Microstrategy 9, SAS/SQL SAS/Graph, PPS 2007

Other Languages/ Technologies / Platforms: C # .net, VB.net, Power Builder 6.5, Visual Studio, HTML, XML, CSS, Erwin 4.1

PROFESSIONAL EXPERIENCE:

Confidential

PS consultant

Responsibilities:

  • Validated tables/partitions to move early, for any Confidential tables, determine actual size
  • Developed automated Data mover/QueryGrid Script to load data into Confidential and Hadoop server
  • Designed developed staging database environment
  • Data mover/QueryGrid to move tables/partitions i.e. For PPI tables, only partitions not already migrated, Full tables for all others and Execute in ETL Load priority and Business Priority sequence
  • Migrated almost 500TB+ of data to the staging
  • Error handling and debugging in existing PPI table issues related to SCD

Confidential

Tools: & Technologies: Confidential, Data Mover,QueryGrid, Unix

PS consultant

Responsibilities:

  • Prepared various design document with the help from third party Acxiom
  • Leading the team of non-hemisphere migration
  • Assigning day to day work to the team
  • Requirement gathering with the wells Fargo technical/non-technical team
  • Schema design for the Non-Hemisphere Line of business users in Confidential
  • Data profiling for the complex various schema and deciding the PI, NUSI for the tables
  • Crated DDL, defined indexes, and data profiling for oracle
  • Developing BTEQ script, for Oracle Stored Procedures, to Confidential equivalent. worked for SAS script conversion from Oracle to Confidential .
  • PI analysis, Performance Tuning for long running BTEQ scripts and SPs.
  • Data loading from Oracle to Confidential .
  • Waterfall report conversion from oracle to Confidential
  • Tuned SQL for faster report execution

Confidential

Tools: & Technologies: Confidential, Oracle, SAS/SQL, SAS/GRAPH, SAS/ODS, Bteq

PS consultant

Responsibilities:

  • Prepared various design document with the help from third party
  • Converted More than 70+ SAS procedure, Micros into Confidential store procedures
  • Worked on most complex part in SAS
  • Error handling and debugging in SAS Micro Scripts.
  • Validated the dataset and comparing result to the source programmers output
  • Developed ETL script to load data from SQL server to Confidential using TPT, SAS DI and SSIS
  • Worked with Confidential architecture to design LDM and PDM for new environment
  • Testing and debugging the waterfall reports
  • Investigate, prepare analyze and validate data for down streaming modeling and analysis
  • Modified the datasets as per the requirement of statistician
  • Used to extract data from SQL Server

Confidential

Tools: & Technologies: Confidential, SQL Server, SSRS 12, SSIS 12/14, TPT, SAS/SQL

Lead consultant

Responsibilities:

  • Prepared various POC document required by Customer
  • Design and developed more than 18 transformations and mappings of ETL using SSIS 12/14
  • Migrated 10 SSRS reports and makes compatible to the Confidential environment
  • Convert more than 30+ Store procedure (SQL server to Confidential )
  • Worked on most complex part Confidential XML
  • Error handling and debugging in existing ETL Scripts.
  • Successfully deliver the expected result to the customer

Confidential

Tools: & Technologies: Confidential, SQL Server, SSRS 12, SSIS 12/14, TPT

Lead consultant

Responsibilities:

  • Completed analysis for the Confidential existing ETL solution which were design in Microsoft SSIS, Approx. 450+ SSIS Solution
  • Suggest architectural improvements, design and integration solutions, and formulate methodologies to optimize database development
  • Providing the high level/detail level solution to the Confidential team whenever required
  • Given revive on requirement list and help to refine the requirement.
  • Assigning work to team and reviewing the changes as per proposed approach and helping them to improve
  • Created high level design and mapping document per requirements.
  • Agile work with Confidential PS Sales for the estimate and architecture related to project

Confidential

Tools: & Technologies: Confidential, Oracle, Microsoft SSIS 2012

ETL Lead /Architect

Responsibilities:

  • Design and developed all the history load ETL solution using Microsoft SSIS, SQL Server and Confidential utilities
  • Configure the Customer Development/SIT environment and install the required software’s on the common server
  • Provide good estimates for development, unit testing, SIT testing and complete deployment of project.
  • Assigning work to team and reviewing their codes and helping them to improve
  • Creating high level design and mapping document as per requirements.
  • Creating deployment instruction and knowledge transfer to Confidential Support team for the new codes developed.
  • Provided Daily updates to onshore coordinator about the status of development.

Confidential

Tools: & Technologies: Confidential, BTEQ, SSIS 2012, Datastage

ETL Lead

Responsibilities:

  • Prepared various POC document required by Customer
  • Designed conceptual data model based on the requirement, interacted with non-technical end users to understand the business logic and designed ETL load accordingly i.e. stage table, target table and DDL
  • Modified PDM as per requirement
  • Delivered BRD and the low-level design document designed the Data model PDM, data flow and data mapping with the application development team.
  • Helped developing PL/SQL packages, Conducted Unit testing, coordinated the production deployment and resolved Post implementation issues. Provided Maintenance & Support of the existing applications
  • Design and developed more than 250+ transformations and mappings of ETL using TPT, BTEQ
  • Error handling and debugging in existing ETL Scripts.
  • Prepared Unit Test Specification Requirements.

Confidential

Tools: & Technologies: Confidential 12, Bteq, TPT, Informatica 8.6

Global delivery consultant (Sr.)/Module Lead

Responsibilities:

  • Coordinating with client and onsite coordinator in day to day activity
  • Testing for ensuring conformity to business requirements.
  • Prepared various POC document required by Client
  • Design and developed more than 300+ transformations and mappings of ETL and various SSIS packages for bulk load, incremental load using CDC (change data capture) and Confidential Attunity drivers.
  • Prepared Unit Test Specification Requirements.
  • Defect logging and fixing them as part of routine work
  • Providing real-time production support for timely and correct fix to production problems.

Confidential

Tools: & Technologies: MS SQL Server 2008, Confidential 12, SSIS 08

Global delivery consultant (Sr.)/Lead

Responsibilities:

  • Coordinating with client and onsite coordinator in day to day activity
  • Testing for ensuring conformity to business requirements.
  • Responsible for developing Public Objects
  • Developed Static Reports and Dashboards.
  • Created required datasets for developing dashboards
  • Involved in creating various objects like panel stacks, panels, selectors, widgets, hyperlinks, derived metrics and thresholds
  • Providing real-time production support for timely and correct fix to production problems.

Confidential

Tools: & Technologies: Microstrategy 9, Confidential

BI Developer

Responsibilities:

  • Prepared various POC document required by Customer
  • Modification in existing transformations and mappings of ETL.
  • Error handling and debugging using C# script embedded in SSIS 08.
  • Modification of existing Dashboard.
  • Enhancement in existing data Cubes and suggested new changes in schema
  • Prepared Unit Test Specification Requirements.
  • Collaborate with data architects for data model management and version control.
  • Capture technical metadata through data modeling tools.
  • Created data objects (DDL).
  • Enforce standards and best practices around data modeling efforts.
  • Ensure data warehouse and data mart designs efficiently support BI and end user

Confidential

Tools: & Technologies: MS SQL Server 2008, Confidential, SSIS 08, SSRS 08, PPS 2007

Global delivery consultant (Sr.)

Responsibilities:

  • Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
  • Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
  • Developed and implemented measurements for various marketing campaigns for retail banking.
  • Created a net loss model which analyzes the impact of loan defaults and recoveries.
  • Created a relational model and dimensional model for online services such as online banking and automated bill pay.
  • Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
  • Developed logical data models and physical data models using ER-Studio
  • Conducting a detailed requirement analysis with Retail Team in Confidential .
  • Coordinating with Customer and onsite coordinator in day to day activity
  • Assigning work to team member.
  • Testing for ensuring conformity to business requirements.
  • Installation, configuration MSSQL Server 2008, Oracle 10g
  • Designed database in MSSQL Server 2008 and SSIS Packages for loading data from Oracle Database to SQL Database
  • Designed and developed cube and semantic layer in SSAS which assure all the fact and dimensions are considered for appropriate business requirement
  • Developed More than 40+ reports, charts for business users and documentation related to project.
  • Providing training to Business Users on Report Builder 2.0.
  • Defect logging and fixing them as part of routine work
  • Providing real-time production support for timely and correct fix to production problems.
  • Dealing with System security department of Customer for different Audit log related to Application.

Confidential

Tools: & Technologies: MS SQL Server 2008, SSIS 08, SSRS 08, Oracle 10g

Tech Lead

Responsibilities:

  • Conducting a detailed requirement with Client.
  • Installation, configuration MSSQL Server 2005/08.
  • Working in team which involves in sending reports of DAR, sales and marketing activities
  • Designed database, and SSIS Packages for loading data from excel to SQL Database
  • Developed More than 50+ reports and charts for analysis.
  • Defect logging and fixing them as part of routine work
  • Providing real-time production support for timely and correct fix to production problems.

We'd love your feedback!