SUMMARY

• Data warehouse and ETL professional with 6 years of software development experience with global clients using Agile based test driven development methodologies, maintaining data warehouse systems performing data integration, data migration using business analytics, ETL and CRMS tools.
• Have 3 + Years working experience as Salesforce Business Analyst.
• An Expert in Data Migration/Integration projects with rich experience on ETL tool Informatica 9.1, Salesforce.com, MS SQL server, Sybase, DB2,Oracle Tableau Reporting Tool, Unix Scripting, Windows scripting and Power Shell scripting
• Good knowledge of RDBMS and Data Warehousing concepts.
• Have extensive experience in business process analysis/modeling, business requirements gathering, database design and Experience in writing stored procedures, views and triggers for data consistency and manipulation.
• Good financial domain background in financial services and banking including Global Wealth and Investment Management, Treasury, Asset Management and trading.
• Lead projects from initialization phase from capturing business requirements to final phases of deployment using SDLC methodology.
• Strong Communication Skill.
• Experience creating custom objects and integrating existing desktop and web apps with legacy mainframe systems.
• Created page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.
• Implemented pick lists, dependent pick lists, lookups, junction objects, master detail relationships, validation and formula fields to the custom objects.
• Possess comprehensive understanding of CRM business processes like Campaign Management, Lead Management, Account Management, Case Management, Quote, Forecasting, and Call Center.
• Extensive knowledge of Salesforce.com implementation cycle in Sales, Marketing, Service and support modules.
• Skilled in customizing standard objects like Accounts, Contacts, Opportunities, Products, Price books, Cases, Leads, Campaigns as per client’s need.
• Experience in data migration from ACT, Excel, MS outlook and Legacy Systems using Data Loader, Import Wizard, Informatica Data Loader.
• Expert in generating and analyzing custom reports and dashboard for management and various business unit personnel to provide detail information on key performance indicators.
• Developed process enhancements through automations including Workflow, Approval Processes, and Escalation Rules.
• Knowledge in Salesforce.com SFA, Force.com Apex Classes, Apex triggers, Integration, Visual force, Force.com API, SOQL, and SOSL.
• Ability to quickly adapt to changing priorities, requests, and environments. Experienced in End user training, documentation and application/product demos. Dedicated to maintain high quality standards.
• Analyzing the user requirements and providing the solution for various Data Warehousing related Development/Enhancement projects.
• Proficient knowledge of using scheduling tools like “Autosys” and Control - M
• Have extensively worked with Agile methodology and Lean Process
• International experience for work and client relationship building.
• Used QC for testing support and Jira for project management.
• Experience in database design with SQL Server 2005/2008 R2, Oracle 8.0
• Experience in SQL Server Integration Services.
• Expertise in Database Programming and Development using MS SQL Server 2008/2005
• Experience in source control and version control (Perforce, SVN, MS Visual Source Safe and TFS).
• Extensive knowledge of Database Design, Database Programming and Normalization using SQL Server.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery
• Intricate understanding of modeling business requirement into software architectures using Object Oriented (OOAD) methodologies, design patters for developing reusable code and class libraries.
• Possess excellent knowledge in OOP concepts
• Knowledge of Test Driven Development.
• Extensive experience in SCRUM and Agile methodologies
• Exposure in Requirement Analysis, Architecture & Design Documentation, Reviews, System Development, System Testing, System Implementation, User Documentation.

TECHNICAL SKILLS

Programming Languages: Advanced PowerShell, UNIX and Windows scripting, T-SQL, PL/SQL

ETL Tools: Informatica Power Center 9.0/8.x/7.x, Informatica Power Mart 6.2/5.1/4.7, Informatica Power Exchange Salesforce.com

CRMS Tool & Application: Salesforce.com, SalesForce Apex Explorer, SalesForce Data Loader

RDBMS: MS SQL Server 2005, DB2, Sybase.

Scheduling Tools: Autosys, Plato, Contorl-M, Informatica Scheduling.

Reporting Tool: Tableau

Version Control Tools: Visual Source Safe, Tortoise SVN

Modeling Tools: MS- Visio.

Process methodology & Tools: Lean process, Six Sigma, Agile, JIRA.

Servers: Windows Server 2003/NT, Microsoft IIS (4.0/5.0/6.0/7.0 ), UNIX

Industry\Domain knowledge: Investment Banking, CRM, Asset Management, Regulatory Compliance

PROFESSIONAL EXPERIENCE

Confidential, NYC

Environment: Informatica 9, Sybase 15, JIRA, Jenkins

Responsibilities:

• Gathered business requirement for each new type of alert, document and developed sybase procs and ETLs.
• Create and tested control M jobs
• Gave testing support to product.
• Worked on the Agile methodology to cut down the time and deliver the results.
• Worked with Unix scripting.
• Writing T-SQL queries & procedures for fetching data from database
• Created Procedures (PL/SQL) and User defined functions using SQL server 2008
• Writing Test Cases and Technical Specifications documents
• Used VSS, Tortoise SVN for versioning of code
• Worked with Business Analyst closely to gather most of the Business Requirements for all the Line of Businesses
• Participate into worked of Data Modeling while designing the various Line of Businesses and integrating together
• Data Store by Scrubbing, Cleansing and Transforming data before its being utilized by the Downstream Systems.
• Customized Informatica Mappings, Configured, Scheduled and Executed Full and Incremental loads on Data Store.
• Assisted the reporting developers and Data Modelers to ensure the ETL addresses the scope of reporting adhering to the required standards.
• Supported trouble shooting for the Data Issues on the ETL side and documented the resolution history for all the issues.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Used Greenhopper tool for Agile process.
• Participated in daily scrum meetings and storyboard activty

Confidential

Sr. ETL Consultant

Environment: Informatica 9, Powershell scripting, JIRA, Databases: Oracle 10g, Sybase, Control-M.

Responsibilities:

• Developed complex informatica mappings and workflows for business logic.
• Gathered business requirement for each new feed that was sent via upstream or had to be sent to downstream
• Worked on the Lean Process to cut track efforts closely.
• Worked with Windows scripting
• Writing T-SQL queries & procedures for fetching data from Sybase 12 and Oracle
• Created Procedures (PL/SQL) and User defined functions using Sybase 12 and Oracle
• Writing Test Cases and Technical Specifications documents
• Create jobs and scheduled them using PLATO, a scheduler.
• Implement performance tuning opportunities and reporting efficiency of incoming and outgoing processes
• Support business team with their queries and provide extract from the SQL database as needed.
• Installation and Configuration of the Sybase, PLATO monitor and Informatica 9 on the development environment and QA box.
• Extensive used of JIRA for daily effort tracking as part of Lean process
• Attended daily stand up meetings. Monthly Pokersizing activity as part of Lean process was performed
• Extensive support to all development items in QA regression cycle before go live.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Confidential

Technical Architect

Environment: Tableau Desktop and Server, JIRA, Databases: Sybase.

Responsibilities:

• Worked on reporting tool Tableau
• Created reports for business approvals.
• Created Roles and access set up for users
• Created deployment groups and managed to create a model of deployment for deployment team to manage in all environments.
• Created reports, test plans and unit tested it
• Strong knowledge of tableau dashboards development
• Proven experience in developing functional applications and systems of medium to high technical complexity
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Extensively used calculated fields for different logics for Trend,Extended price calculations for the different cost types.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.

Sr. Software Engineer/BA

Confidential

Responsibilities:

• Created user Roles and Profiles and sharing settings.
• Used field level security along with page layouts to manage access to certain fields.
• Designed and deployed Custom tabs, Validation rules, and Auto-Response Rules for automating business logic.
• Created workflow rules and defined related tasks, email alerts, and field updates.
• Implemented pick lists, dependent pick lists, lookups, master detail relationships, validation and formula fields to the custom objects.
• Created various Reports and Report folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the needs of the organization.
• Created APEX triggers, classes, test methods and visual force pages to implement custom functionality.
• Used SOSL and SOQL queries during the data migration and custom development.
• Current System Analysis and Requirements Documentation Impact Analysis, High Level & Detailed Design, Development/Testing, Full support and maintenance
• Developed complex informatica mappings and workflows for business logic.
• Worked with complex Windows scripts.
• Writing T-SQL queries & procedures for fetching data from database
• Created Procedures (PL/SQL) and User defined functions using MS SQL 2005/2008
• Writing Test Cases and Technical Specifications documents along with test support and production support.
• Business Analysis post go live to analyze the type of data being consumed
• Load balancing techniques, Support activities performed in production
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (Salesforce,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Web service Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.

Senior Software Engineer

Confidential

Environment: Windows scripting, Salesforce Data Loader, Apex Explorer, Apex Data Loader, SOQL

Responsibilities:

• Worked on various Salesforce.com Standard objects like Accounts, Opportunities, Leads, Campaign and Reports.
• Created various Custom objects, Tabs, Workflows, Reports, Apex triggers and validation rules for the application.
• Analyzed and Created Custom Profiles as required for the business needs and implemented Object level, Field level and Record level security.
• Defined various Validation rules to validate the data in the application.
• Customized Page Layouts for Salesforce.com Standard and Custom objects.
• Created custom report types and generated report using the report types.
• Good experience in Salesforce.com Configuration of roles, profiles, user accounts, implemented role hierarchies, sharing rules and record level permissions to provide shared access among different users.
• Used Data loader for all data adding, updating, and deleting, exporting data.
• Used Eclipse IDE for building scripts and deployment
• Documented Sales force fundamentals and reporting for easy understanding and navigation for business users
• Aggressive salesforce custom objects analysis.
• Current System Analysis and Requirements Documentation Impact Analysis, High Level & Detailed Design, Development/Testing, Full support and maintenance
• Business Analysis post go live to analyze the type of data being consumed
• Support activities performed in production with regards to data

Confidential

Systems Engineer

Environment: Informatica 8.6.1, Unix scripting, Databases: DB2

Responsibilities:

• Current System Analysis and Requirements Documentation, Impact Analysis, High Level & Detailed Design, Development/Testing
• Worked with complex UNIX scripts.
• Developed Informatica mappings
• Autosys jobs scheduling
• Global team coordination in USA and India
• Participate in Design Reviews of Data model and Informatica mapping design.
• Assisted in creating Logical and Physical data modeling.
• Worked on Mapping designer, workflow designer, workflow monitor etc. of Informatica.
• Development of mappings workflows and session tasks using Informatica Power Center.
• Examining the session logs if the workflows fail and fixing up the defect.
• Debugging mappings using Debugger tool in Designer.
• Unit testing the reports, debugging and fixing the errors for Right reports.
• End to End testing of Reports for data and functional behavior.
• Providing support and fixing issues related to Data on Reports, Dashboards etc.
• Provided RPD support to manage the Reports and Dashboards
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis,