Phone # 832-***-****

ac327t@r.postjobfree.com

HIMAJA PATSA

OBJECTIVE: Seeking a position which allows optimal utilization and application of my technical and communication skills, with a driving force that aligns with the goal of the company and opens up a window for growth.

SUMMARY:

●4+ years of experience on user requirement gathering, development of Business requirements documents(BRDs) and functional specifications.

●Solid experience in Data Modeling using designed tool Erwin, Oracle SQL Developer, SQL Server Management studio, Mysql, SQLPlus and Toad. Hands on experience with PL/SQL programming and writing SQL queries.

●Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS). Worked Extensively on ETL process using SSIS packages.

●Progressive expertise in analyzing the requirements, application design, development, testing and production support for various environments.

●Proven experience in relational and dimensional data modeling, data management, data warehousing, data transformation, data profiling, metadata and master data (reference data) management and business intelligence tools.

●Scrum Master with strong technical background and strong understanding of project management methodologies including both Agile Scrum and Waterfall.

●Hands on experience with HTML5 and XML and proficiency in tools like Keil, MathCad, Maya, Unity Pro7, Virtuoso, PeopleSoft, Blackboard vista and Learn.

●Product managerial experience, assessing cross-functional business requirements for SDLC-driven IT projects.

●Industrial experience coupled with communication skills which would help in effective productivity.

EDUCATION:

●Masters in Computer Engineering

University of Houston, Houston, TX. GPA-3.6/4

●Bachelor of Technology in Electronics and Communication Engineering

Jawaharlal Nehru Technological University, A.P, India. GPA-3.8/4

SKILLS:

●Languages PL/SQL, T-SQL, C, C++, Verilog, MATLAB, VHDL, Python,R, VBA,SAS,Macros.

●Technologies/Tools Keil, MATHEMATICA, Mathcad, Simulink, Cadence, Virtuoso, AutoCAD, Actimize,

Autodesk, SSMS, TOAD, SSIS,SSAS,SSRS,SAS EG,MS-Office, SPSS, Blackboard Vista,

SharePoint Designer, PeopleSoft, Unity Pro 7, Hive, Maya, Informatica, QlikView, Qliksense

Oracle 8i/9i/10g, MS-SQL 2000, MS Access, OBIEE 10.x, 11.x, JIRA,Tableau,Confluence.

●Web Servers Microsoft IIS 6.0, oc4j, Web Logic.

●Web Development HTML, CSS, XML, Adobe Dreamweaver.

●Operating Systems Windows, Macintosh.

WORK EXPERIENCE:

Business Analyst, Bank of America, Charlotte, NC. (April’16-Present)

●Involved in the design, development and modification of system applications.

●Worked as a part of Global Compliance team analyzing systems, processes, reports and data archives from a worldwide network.

●Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications and implemented different types of constraints on tables.

●Extracted and loaded data into SQL Server Database using SSIS.

●Used data profiling automation to uncover the characteristics of the data and the relationships between data sources before driving the data along with understanding the data and mapping document.

●Extensively involved in designing the SSIS packages to export data from flat file sources to SQL Server databases.

●Designed and implemented Sharepoint web parts with display templates & workflows and solutions in line with SDLC process.

●Created and deployed electronic InfoPath forms which are maintained from time to time. Used R to auto-populate the Infopath forms which is a part of the Test Migration project.

●Conducted a time-sensitive, meticulous investigation and analysis of each instance of potential Anti-Money Laundering activity (Actimize) and/or suspicious financial activity across multiple jurisdictions and countries, utilizing multiple research and analytical tools.

●Worked on data integration, data transformation, metadata management, ETL, data modeling tool sets.

●Responsible for helping to capture business requirements, identifying appropriate data sources, data quality issues, business transformation rules, mapping source to target.

●Provided analytical support in EIT activities related to multiple Compliance Control Functions.

●Gathered and organized data in order to track, report and monitor the effectiveness of bank controls while identifying and escalating regulatory issues to management.

●Experienced in branding Sharepoint site collections and team sites by modifying the master pages, page layouts and CSS styling.

●Worked on enterprise-wide data Governance policies, standards and data Framework to govern full data life cycle including data creation, usage, retention and deletion.

●Performed quality reviews on proposed bank-monitoring activities by analyzing data generation methodologies applicable to company standards, while also developing methods and procedures to conduct bank-monitoring activities.

Data Analyst, GE Transportation, Erie, PA. (May’15- Mar’16)

●Involved in extensive Data validation using SQL queries and back-end testing.

●Worked with Design and Development team to implement requirements.

●Served as Scrum Master on a scaled agile program with 180 team members and Agile coach.

●Performed data analysis, primarily identified data sets, source data, source Metadata, data definitions and data formats.

●Defined and implemented Enterprise Data Management services from a technology perspective while understanding the business drivers.

●Led Lean Six Sigma project to reduce the number of patient cancellations or absentees by developing a process improvement plan and increasing savings by $300K.

●Provided 24x7 support of eight Oracle Applications EBS environments running release R12.1.3. Acted as the Lead team member responsible for all database activities associated with the support of Oracle Applications HR, Financials Suite, Purchasing, Self Service, and Inventory. Successfully completed an upgrade of EBS from 11i to 12.1.3 ahead of schedule and under budget.

●Created dashboards using key performance indicator (KPIs) such as employee headcount, employee turnover, employee on-boarded, etc.

●Defined roles for Master Data-Governance and rationalize organization to best facilitate policy/procedure compliance and data quality improvement.

●Developed and delivered KPIs, metrics and quality reports to quantify compliance with policy, data quality, and overall effectiveness of the Master Data Governance program.

●Provided suggested improvements to the preliminary Data Governance processes, templates and best practices based on proven best practice.

●Designed both normalized and denormalized dimensional data structures. Created reports by changing the procedure of the query. Helped in running the workflow in ETL.

●Worked on Data Cleansing, Data Transformations, Data Mining, Data Relationships, Source Systems Analysis and Reporting Analysis.

●Completed primary and secondary validation by providing unit test cases.

Instructional Technology Assistant, University of Houston Law Center, Houston, TX. (Aug’13-May’15)

●Assisted faculty in Blackboard and SharePoint. Supported elementary instructional personnel with the presentation of technology-based instructions and exercises in the classroom or computer laboratory, installed and maintained hardware and software campus-wide.

●Maintained and designed University of Houston Law Center Sharepoint lists and views. Conducted quizzes for Students through Sharepoint Designer- Turning Point tool.

●Assisted in standardization, documentation, and implementation of overall physical data management and data release processes.

●Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language. Performed data analysis on climatic data using cross validation techniques.

●Utilized SAS, SQL, and occasionally R to conduct statistical analysis on a variety of institutional and academic related data.

●Generated various internal reports and data requests regarding graduate education at the University of Houston Law Center.

●Worked with Stored Procedures to handle various checks, to generate the ballot and the voting demographics were written in SQL Server 2008.

●Worked with Adobe Dreamweaver and HTML5 to create and edit web pages in the Law Center Website. Posted the daily news and events. Updated the syllabus and faculty lists. Designed the website.

Data Analyst/Business Analyst, ADP India (Nov’12 – July’13)

●Involved in Gathering, Analyzing Business Requirements for Reports.

●Created/Modified Metadata repository, defined/developed Physical Data Layer, Business Model (Aggregates, Dimensions and time Series functions) and Presentation Layer using BI Tool.

●Responsible for solving all the technical problems related to Teradata and intensively worked on the Teradata SQL part, as well as the Utility part of Teradata.

●Coordinated the collection of metrics across multiple sources including SQL databases, manual daily reports, and email driven activities. Wrote SQL and PL/SQL queries to analyze data.

●Conducted detailed analyses of complex systems using Excel, Access, and SQL Server Management Studio.

●Conducted independent analysis by quantitatively analyzing data/information. Developed and presented oral and written analyses to support operational goals to management.

●Provided analytical support and documentation for databases after collaborating with IT to prepare current systems for migration to new business intelligence system.

●Performed ad-hoc data analysis and creation of reports using SQL and Excel.

Contact this candidate