SUMMARY

• Over 7+ years of experience as Data Analyst, Data Steward, Business Analyst and technical lead. Expertise in SAS, Oracle PL/Sql, SQL and Teradata
• Experience in Data Management processes, Business and technical metadata reviews.
• Sturdy problem - solving ability, with a talent for identifying the root cause and devising innovative solutions.
• Extensive qualifications in all facets of information systems methodology from conceptual design through documentation, implementation, user training, quality review, analyzing business specifications, translating user requirement into functional use cases for analysis and development.
• Strong team leader, able to guide the team in delivering above and beyond expectations throughout all stages of application.
• Expertise with BASE SAS, SAS MACROS and PROC SQL.
• Expertise with databases like oracle and Teradata. Exposure to SQL server.
• Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes.
• Strong Exposure in writing simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Functions, Packages, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Experience in advanced SQL and PL/SQL concepts like Hash joins, Hierarchical queries, Bulk collect and FORALL, Dynamic SQL, Records, collections, global temporary tables, pivot tables, parallel queries.
• Proficient in tuning SQL queries using HINTS and EXPLAIN PLAN.
• Experience in Design, Development and Implementation of SharePoint portals.
• Strong domain experience in Credit Cards, Banking and Auto Finance.
• Strong ability to adapt and learn new technologies and new business lines rapidly.
• Excellent interpersonal skills, including the ability to coordinate and motivate team members.
• Ability to work independently with minimal supervision.
• Excellent presentation, written and oral communication skills.
• Ability to prioritize and run multiple tasks simultaneously.

Areas of Expertise

• System Analysis Data Collection, Evaluation, Proposing Solutions
• Data Quality Management Technical and Business Metadata Reviews, Data Quality
• And Data Movement reports
• Portal Development SharePoint portals, InfoPath forms

TECHNICAL SKILLS

Language: SAS, PL/Sql, VB Script, Visual Basic6.0, Java Script

Database: Teradata, Oracle, SQL Server

Tools: Metadata Hub, Informatica Data Quality Tool, SQL* Plus PL/SQL Developer, Toad, SharePoint, InfoPath, Front Page, Visual Studio 2007/2010

Version Control Tools: Clear Case and Visual Source Safe

Application: MS Word, Visio, Excel, PowerPoint, Outlook

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

DATA STEWARD/ANALYST

Responsibilities:

• Responsible for reviewing, maintaining and consolidating the metadata for all the projects that will be implemented in Data warehouse environment.
• Maintain and administer the corporate metadata repository.
• Responsible for monitoring the daily data movement from source system to the ware house environment and to the presentation layer of the Teradata environment.
• Interacted with business analysts and technical leads from other platforms to gather the key elements of data which need to be monitored on a regular basis.
• Perform impact analysis to assess impact of source changes to the warehouse environment.
• Responsible for rewriting the existing data quality reports in SAS
• Developed new reports in SAS using SAS ODS, PROC REPORT, PROC TABULATE, and PROC SQL.
• Imported Data from relational database into SAS files per detailed specifications
• Responsible for the development and maintenance of SAS Information Maps for Analytics and Business forecasting Team
• Write complex SQL queries with sub-queries, analytical functions, pivot functions and inline views
• Provided many innovative solutions for streamlining the data quality check process and managing the requests/ queries from analysts regarding warehouse environment.
• Advised Share Point portal as a platform to socialize and manage data quality processes across Capita One and also acted as single point of contact for the getting the portal ready as per the requirement.
• Acted as an admin to Data management SharePoint portal.

ENVIRONMENT: Teradata, Oracle, SQL, SAS, Metadata Hub, Informatica Data Quality tool

Confidential

ANALYST AND TECHNICAL LEAD

Responsibilities:

• Source system analysis/ Impact Analysis.
• Coordinate with business analyst to understand the data requirements.
• Responsible for designing the database modules required for data retrieval.
• Analyzed the business requirement and provided optimal solution.
• Reviewed the high level design with Architects.
• Provided the high level design for the backend oracle stored procedures required for data retrieval.
• Created database objects like Tables, Sequences and Constraints as per the business requirement.
• Created database views and materialized views.
• Created database triggers based on requirement analysis.
• Developed stored procedures, functions, packages based on requirement.
• Unit test and debug developed software. Provided support for UAT by providing the required data and clarifying all open questions.
• Provides clarifications, draws consensus & sets prioritization for the issues in production.

ENVIRONMENT: Oracle PL/Sql, SQL

Confidential

BUSINESS ANALYST & DEVELOPMENT LEAD

Responsibilities:

• Responsible for gathering specific requirements from various lines of business.
• Created Master and content pages using SharePoint Designer to enable conditional formatting and implement consistent look and feel.
• Used Share Point object model to retrieve, change, and insert items in a list, files in a document Library and Custom Lists.
• Design & Development of SharePointWeb Parts Using Visual Studio 2010.
• Programming workflows that support Serial/Parallel execution, Send email notifications, enable Timeouts and Escalations, Delegation of task to peers etc.
• Developed Custom Activities for various Workflows.
• Created InfoPath forms for submitting the project intake details.
• Used Java script for writing custom code in InfoPath form.
• Designing active directory naming strategy and Design an active directory domain.
• Worked as a SharePointadministrator giving permissions to users.
• Provides clarifications, draws consensus & sets prioritization for the issues in production.
• Served as primary client contact for assigned project.

ENVIRONMENT: SharePoint 2010, Microsoft Visual Studio 2010, Share Point Designer, InfoPath

Confidential

DEVELOPER

Responsibilities:

• Understood and analyzed the business requirements to provide an effective solution.
• Interacted with the business groups in Creation/Modification of the functional specifications.
• Created the design specifications (High Level and Detailed Design)
• Extensively used Microsoft software applications, i.e. Word, Excel, Microsoft Project, PowerPoint and Visio
• Drawn flow charts and data flow diagrams.
• Took the ownership of all the desktop applications that are built in VB6.
• Mentored peers in design and development related to Oracle stored procedures, functions and packages.
• Experience in onsite-offshore business model and coordinating with team in off-shore.
• Responsible for meeting deadlines for the change request or enhancement.
• Responsible for Review and Sign offs from the customer.
• Responsible for rollbacks in case of issues in Production.
• Responsible for smooth rollout and keeping a check for the first cycle of Production runs
• Developed schema objects like indexes views, stored procedures, synonyms, Triggers, PL/SQL stored procedures and functions.
• Wrote packages using refcursors, cursors, pl/sql tables, types, bulk collect.
• Involved in developing and maintaining control files for SQL loader to load the data files to tables in oracle database.
• Used SQLTrace and TKPROF for assessing the efficiency of SQL queries.
• Prepared unit test cases and executed the same and verified actual results with expected results.
• Worked closely with QA team in testing the developed Program units and successfully moving them to Production.
• Consistently involved in resolving the critical production issues.

ENVIRONMENT: VB6, Oracle10g, PL/SQL, UNIX Shell Scripting

Confidential

SOFTWARE ENGINEER

Responsibilities:

• Involved in System analysis, writing design scope documents and implementation specifications. Prepared the design document for the proof of concept.
• Given a demo on Oracle Queuing and UTPLSQL (testing software).
• Developing code for the front end application interfaces in oracle.
• Developed code for the database synchronization between Sybase and Oracle in Oracle Queuing.
• Wrote some UNIX scripts for automation of testing.
• Prepared unit test cases and executed the same.
• Extensively participated in Unit and Integrated testing.
• Consistently involved in resolving the critical production issues.

ENVIRONMENT: Oracle PL/SQL and Oracle Queuing.