Ajay Sharma Data Modeler \Data Analyst
Senior Data Modeler/Analyst with over 8 years of experience in data analysis with experience in Financial, Healthcare and Insurance domains. SKILLS INVENTORY Strong background in business intelligence, reporting systems, data quality (including ETL), and full life-cycle development. Extensive experience in designing robust data models using Erwin, ER Studio, Sybase Power Designer and VISIO. In depth Functional knowledge of customer’s business, Process flow and procedures of various domains as well as building customer relationship skills. Involved in the various phases of software life cycle (Analysis, Design, Development, Testing and Production/Maintenance) for the projects using methodologies like Agile, RUP, Waterfall, and hybrid methods. Designed and developed Data models for Database (OLTP), the operational data store (ODS), Data warehouse (OLAP), and federated databases to support client enterprise Information Management Strategy. Vast experience of working in the area of data management including data analysis, gap analysis and data mapping. Worked extensively with Erwin, Visio and ER Studio, Power Designer for Relational, Dimensional Modeling and Data Migration projects. Adept at writing Data Mapping Documents, Data Transformation Rules, creating and maintaining Data Dictionary. Extensive experience in Database Management in managing SQL Server Databases Developed reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture. Supported team in resolving SQL reporting services related issues. Extensive experience in Performance tuning databases for optimum performance Coordinated and prioritized outstanding defects and system requests based on business requirements. Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators. Proficient in SQL Server developing Stored Procedures, Triggers, T-SQL Statements, Cursors, User Defined Functions and Views. Solid problem-solving skills, with proven ability to create software solutions for diverse needs. Good team building skills; acute ability to interface with senior management utilizing well-developed communication and interpersonal skills. Technical Skills: Languages : SQL, PL/SQL, Visual Basic, .NET, HTML, Operating Systems : Windows, UNIX, MS-DOS Modeling Tools : Erwin Data Modeler, Power Designer, ER/Studio, Microsoft Visio Reporting Tools : Crystal Reports, OBIEE, Microsoft Reporting Services, Cognos ETL Tools : Informatica, Abnitio Other Tool : Exadata, MS Office (Word, Excel, PowerPoint), MS Project 2003 MDM Tools : Ebx5 Relational Databases : MS Sql, Access, Oracle, Teradata, and Netezza Please add ke...@ilogicnet.com <k...@ilogicnet.com> to your mailing list for requirements and hot lists. Look forward to work with you -- -- Thank you Kevin Technical Recruiter ilogicnet Consulting ke...@ilogicnet.com <k...@ilogicnet.com> Contact number: 502-379-5014 -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.