Ps Consultant Resume
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 consultantResponsibilities:
- 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.