SUMMARY

• An Information technology professional with more than 5 years of extensive experience in all phases of Software development life cycle including System Analysis, Design, Data Modeling, Implementation and Support of various web based applications in OLTP, Data Warehousing, and OLAP applications.
• Extensive Experience on Creating Visualization Dashboards using Confidential.
• Very large database optimization and performance tuning to address data latency requirements utilizing performance analysis, execution plans, Bitmap Indexing, Partitioning, Materialized Views, Parallel Queries, Merge and Pipelines.
• Enterprise wide applications security and compliance standards and best practices.
• Collaboration software (SharePoint), technical specifications and system documentation.
• Good Knowledge of ETL Processes such source, mapping, transformation, staging areas and created various ETL documents such as ETL Mapping documents, Data Mapping documents, ETL test scripts etc.
• Extensive Experience working with business users/SMEs as well as senior management.
• Strong understanding of the principles of Data warehousing using Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Strong experience with Database performance tuning and optimization, query optimization, index tuning, caching and buffer tuning.
• Good knowledge in analysis and reporting using various Business Intelligence tools such as Confidential and Business Objects.
• Excellent verbal, presentation and written communication skills.
• Able to communicate with technical, non technical and senior management audiences.
• Have played a significant role in requirements planning, client interaction and documenting.
• Excellent problem - solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS

Data Modeling Tools: Erwin, (8.2,8.1,7.3.5) Power Designer, Embarcadero

Databases/Tools: Oracle 15g/11g, MS SQL Server 2014, MySQL, Sybase 11.5/11.2, MS Access, Cobol copybook, Mainframe Files, DB2 UDB, XML, SQL Navigator, Toad, Teradata, 12.0 NetezzaETL Tools Informatica PowerCenter 8x 7x/6.1, 5.1, Confidential, DataStage, Ab initio

BI Tools: Confidential, SAP BW, Business Objects, Confidential, OBIEE, Crystal Reports 2008

Architectures: OLAP, OLTP, OOP, SOA, Client-Server

Databases: Teradata, SQL SERVER, Oracle, Mongo, DB

Operating Systems: UNIX, Linux 7.0+, Macintosh 9+, Windows 95/98/2000/XP

Languages: C, C++, JAVA, XML, SQL, HTML, JavaScript, Perl, PHP, Shell Scripting

Webservices Software Engineering Tools: Rational Rose, Requisite Pro

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Data Analyst

Responsibilities:

• Worked with Business Analyst to understand the user requirements, layout, and look and feel of the application to be developed.
• Data blending implemented on SQL Server database and generated interactive dashboards.
• Created ad-hoc reports to users in Confidential by connecting various data sources.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Confidential .
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment.
• Implemented the feedback and incorporated the necessary changes.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Made complex chart like Spider chart and funnel chart to better visualize the data.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Confidential ad-hoc reports.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the department.
• Conducted logical data model walkthroughs and validation.
• Involved in implementing and testing of the developed application data standards.
• Involved in Data analysis for data conversion included data mapping from source to target database schemas, specification and writing data extract scripts/programming of data conversion, in test and production environments.
• Created and maintained the Data Model repository as per company standards.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.

Environment: Oracle 10g, SQL Server 2005, PL/SQL, PeopleSoft V8, Toad, Informatica, Confidential, Power Centre 6.0, Case Management System, Business Objects.

Confidential, Chicago, IL

Data Analyst

Responsibilities:

• Extensively worked on various database impacts on Confidential applications once the impacted changes are known in project requirements review.
• Extensively worked with Model maintenance project where all the Data models which are not to up to standards making them standardized.
• Writing implementation plans in order to implement the database changes into QA and Production environment.
• Extensively worked on creating, Altering and Deleting the Tables in different Development Environments and also Production.
• Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc.
• Extensively worked with logical models to change them into complete physical models from where we can implement these models into database.
• Designed a Conceptual Data Model, Logical Data Model, and Physical Data Model using Erwin.
• Extensively worked with developers on analyzing the impacted changes on respective applications based on which design approach is taken and also same changes are implemented in database with help of DBA.
• Created physical models for the applications which don’t have any physical models from logical models.
• Worked in Implementation of full lifecycle inDataModeler/DataAnalyst,Datawarehouses andData marts with Star Schemas, Snowflake Schemas, and SCD & Dimensional Modeling Erwin r9.5.
• Worked withSQL, SQL PLUS, Oracle PL/SQLStored Procedures, Triggers,SQLqueries and loading data into Data Warehouse/Data Marts.
• Designed and implemented data integration modules for Extract/Transform/Load ETL functions.
• Data blending implemented on SQL Server database and generated interactive dashboards.
• Worked on Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL.

Environment: Oracle 9i/10g/11g, SQL Server 2005, Toad 8.6 for Oracle, DB2, Unix AIX 5.2, Linux, ERWIN 7.3/, Flat Files, Hyperion 8.3.