Sr. Data Analyst Resume
Des Moines, IA
SUMMARY
- 7 years of robust professional experience in Data collection, Data Extraction, Data Cleaning, Data Aggregation, Data Mining, Data verification, Data analysis, Reporting, and data warehousing environments.
- Knowledge of full life cycle software development process SDLC including requirements definition, design, development and maintenance.
- Extensive experience in querying languages using SQL, PL/SQL, T - SQL, SAS.
- Experience in building visualizations for trend analyses, statistical analyses, estimate analyses and forecasting using data visualization tools such as Tableau and TibcoSpotfire.
- Proficient in UNIX shell scripting.
- Understanding of the design and development of high-performance parallel Data Architecture systems like Teradata.
- Prepare proposals for analytics development initiatives and present business cases for new solutions to the Analytics and Reporting Council for review.
- Leverage flexible project management and development methods using Agile and Lean to enable rapid user feedback, iterative development and continuous improvement.
- Understanding of backup, archive, restore and purge strategies and disaster recovery strategies in very large database environments.
- Experience with the monitoring and fine-tuning of large data warehouse implementations using various DW performance improvement options (virtual and materialized views; additional indexes; segmentation and partitioning of the various fact tables; caching, etc.)
- Expert knowledge of Excel VBA with experience creating complex automated database driven tools and reporting solutions in Excel.
- Proficiency in the use of Microsoft Office tools (Microsoft Access, Word, Excel, PowerPoint, SharePoint).
- Exposure to Agile tools like Rally.
- Project Management skills including project proposals, estimation, planning, gap analysis, risk analysis.
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Excellent interpersonal skills, strong verbal and written communications skills - capable of developing well-structured communications and presentations.
- Committed to excellence, self-motivator, fast-learner, team-player, and a prudent developer with strong problem-solving skills.
TECHNICAL SKILLS
Operating Systems: Windows, UNIX, Linux
Languages: UML, SQL, HTML, XML, C, C++, Java, Visual Basic 6.0/.Net
Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase
SDLC Methodologies: RUP, Waterfall, Agile (Scrum, XP), RAD
ETL/BI: Informatica, Crystal Reports, Business Objects, Cognos
Testing Tools: QTP, Mercury Quality Center, Rational ClearQuest, LoadRunner, WinRunner
Other Tools: Rational Rose, MS Visio, MS Office, Erwin Data Modeler, TOAD, Management Studio, PL/SQL.
Reporting tools: Business Objects, Tableau, Crystal Reports, and SSRS &PowerPivot.
PROFESSIONAL EXPERIENCE
Confidential, Des Moines, IA
Sr. Data Analyst
Responsibilities:
- Worked with the analysis teams and management teams and supported them by providing variables based on their requirements.
- Documented technical & functional requirements, use-cases, conceptual designs, and data analytics for multiple business units within the organization. Worked with stakeholders to gather business & technical requirements for Data Warehousing projects.
- Involved in extraction, transformation and loading of data directly from different source systems (flat files/Excel/Oracle/MSSQL/Teradata) using SAS/SQL, SAS/macros.
- Extensively read different forms of Input files like CSV and other formatted files using In-file, Proc Import and documented using SAS scripting to develop data cleaning operations.
- Generated PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
- Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
- Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Packages, Functions and Triggers using SQL and PL/SQL.
- Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques using SAS/Base.
- Wrote Python scripts to parse XML documents and load the data in database.
- Used Python to extract weekly information from XML files.
- Developed Python scripts to clean the raw data
- Developed live reports in a drill down mode to facilitate usability and enhance user interaction
- Query Data from Hadoop/Hive & MySQL data sources to build visualization in Tableau.
- Facilitated the automation process for the Delinquency Report -This report was required to run on a monthly basis.
- Extensively worked on Shell scripts for running SAS programs in batch mode on UNIX.
- Validated regulatory finance data and created automated adjustments using advanced SAS Macros, PROC SQL, UNIX (Korn Shell) and various reporting procedures.
- SAS/STAT procedures such as UNIVARIATE, FREQ, and MEANS were used to carry out analyses and the SAS REPORT procedure is generally used to display results.
- Performed statistical data analysis, generated ad-hoc reports, tables, listings and graphs using tools such as SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL and SAS/STAT.
- Developed statistical reports with Charts, Bar Charts, Box plots, Line plots using PROC GPLOT, PROC GCHART and PROC GBARLINE.
- Extensive use of Procfreq, Proc Report and Proc Tabulate for reporting purposes.
- Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Involved in creating Tree Map, Heat maps and background maps.
- Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging different sources.
- Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
- Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
- Created reports using analysis output and exported them to the web to enable the customers to have access through Internet.
- Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.
Confidential, Chicago, IL
Data / Business Analyst / BI
Responsibilities:
- Extensively involved in the modeling and development of Reporting Data Warehousing System .
- Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans.
- Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
- Conducted UAT testing and developed strategies with Quality Assurance group to implement Test Cases.
- Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager
- Lead client facilitation to gather requirements (Inception phase), there after assisted tech leads in Analysis & Design of architecture using OOAD approach using UML & Rational Unified Process.
- Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
- Participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
- Designed and developed reports for the data in the Data Warehouse using Business Objects / Excel.
- Write and maintain Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) defining new systems operations for the project using Rational Requisite Pro.
- Performed data analysis and ran various SQL queries to critically evaluated test results.
- Gathered requirements and modelled the data warehouse and the underlying transactional database
- Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
- Involved in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Abilities and Informatica Power Center and testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
- Involved in all phases of Software development life cycle (SDLC) using Agile Scrum methodology.
- Create UAT test scenarios, test cases and coordinated UAT efforts.
- Data mapping, report requirements, business intelligence rules for batch processing systems.
- Analyzed and designed Use Case diagrams, Class diagrams, Sequence Diagrams, Business Objects, Domain Object Model, and MS Visio to depict process flows and PowerPoint presentations.
- Implemented Traceability Matrix and User Requirement Specification Document (URS) and verified the functionality coverage.
- Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
- Worked in OBIEE for building answers, Dashboards and custom business reports.Implement RUP SDLC and worked on data modeling using UML.
- Involved in extensive DATA validation using SQL queries and back-end testing
- Developed timelines for project delivery and managed projects and resources to successful completion.
- Created flexible forms and reports using SQL and VBA to read, update and append records to the Oracle tables
- Worked on reporting requirement from the user and the legacy database- to look for a standard report from Oracle or create and tag custom report for BI reports.
- Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
- Extensively working on Data Modelling tools Erwin Data Modeler to design the data models.
- Conducting JAD sessions and gathering software requirements and business intelligence rules.
- Enterprise Data Management requires a strategic approach to choosing the right processes, technologies and resources (i.e. data owners, governance, stewardship,data analysts anddata architects ).
- Prepared documents such as Project Scope, Project Vision, Project Success, Business Requirements, Functional Specification, Data Warehouse Process Flow (SQL queries & Crystal Reports) using MS Office (Word, Excel, Visio) and dashboards
- Wrotepythonscripts to parse XML documents and load the data in database.
- Document functional specifications and RUP required artifacts
Confidential, Boston, MA
Data Warehouse Business Analyst
Responsibilities:
- Established a RUP (Rational Unified Process) centric business analysis methodology.
- Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
- Analyzed and studied Credit Card process and regulations to be complied for card services in detail. Gathered requirements for Search Rates modules.
- Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
- Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
- Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
- Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process' and revenue streams aimed towards problem solving.
- Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
- Was responsible for indexing of the tables in that data warehouse.
- Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
- Responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
- Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
- Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
- Updated the impacted MS Access tables.
- Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
- Extensively worked in designing the Testing approach for the ETL process in the Credit Data Provisioning Enterprise Data Warehouse (CDP).
- Creation of the data mart from existing Operational data Store and other sources.
- Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
- Played a key role in the planning, testing, and implementation of system enhancements and conversions
- Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
- Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
- Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
- Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
- Assisted in presenting reports and analysis to help guide the management.
- Organized cross training of team members and users to become more responsive.
- Assisted in development of training materials for new technology and process improvements.
Confidential, Columbus, OH
Business / Data Analyst
Responsibilities:
- Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
- Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
- Developed Star schema and multidimensional cubes in the OBIEE Physical layer
- Wrote Teradata scripts for data manipulation, data inserting millions of records into tables.
- Developed script to perform Data validation on Account level by using Teradata SQL Assistant, SQL scripts.
- Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
- Transferred data (ETL) to Data warehouse Environment using SSIS and SSAS.
- Building the cubes by using SSAS.
- Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting.
- Used object-oriented analysis and the Rational Unified Process (RUP) and Agile for business requirements, businessprocesses design (Use Cases using UML).
- Worked on automating standardized reporting by integrating corporate data export tools (e.g. CognosReportnet) and Microsoft Office tools (e.g. MS Visual Basic, MS Access, and MS Excel) seamlessly into scheduled, hands-free reporting solutions
- Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
- Experience in data governance/ data stewardship business/systems analyst needed to work as part of a team on data governance and writing SQL queries.
- Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
- Created source table definitions in the Data Stage Repository by studying the data sources.
- Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
- Wrote Test plan and Test cases for the Integration testing and system testing.
- Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
- Run the SQL queries using TOAD and SQL Navigator.
- Used XML for building and parsing of Application Configuration file.
- Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
- Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.