SUMMARY

• Microsoft Certified Professional with 15 + years of experience in Information Technology industry with full project development life cycle.
• Microsoft Certified Technology Specialist in implementation & maintenance sql server 2005.
• Microsoft Certified Professional in Designing a Database Infrastructure by Microsoft SQL Server 2005.
• Incorporated database technologies such as ODBC, OLEBD to interface with ORACLE and sql server for Internet/Intranet and business applications with sql loader.
• Structured and iterative data warehouse and application development lifecycle methodologies.
• Analysis, design, development, and implementation of data warehouse, ETL, client/server and mainframe transactional application. Experienced in rebuilding master database and restoring Master database.
• Maintained production and development on Sql server 2008, Sybase, Informix and DB2 (UDB) database.
• Experience in enrolling users, maintaining security policies, use of DTS, sql loader, SSIS and BCP packages and build reports for testing the data loaded. Expert in designing relational database model and implementation as per business needs.
• Maintained and administered the ETL environment, including rights/privileges/roles/connection strings, repository backup/restore.
• Experienced in using performance Monitor/profiler to solve dead locks/ long running queries.
• Maintained OLTP and OLAP data models using SVN as versioning system. Upgraded from SQL server 6.5 to SQL server 7.0/ SQL server 2000/ 2005/2008/2012 .
• Expert in Table Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, Database Objects authorization,, Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors.
• Wrote Korn shell scripts to monitor Oracle Application database growth and gather Statistics, scripts for automation of the run of reports with the help of UNIX CRON.
• Reviewed the business process requirements including workflow, business rules and forms, and implemented these processes using COTS tools
• Monitor performance and changing performance requirements through application of Database tuning and performance optimization techniques.

TECHNICAL SKILLS

Languages: C#, VB.NET, VB, VBA, Java, JavaScript, C, C++.

Operating System: Windows server 2003, Window 98/2000/XP, Windows NT.

Databases: Sql server 2005/2008/2012 , Sybase Microsoft SQL ServerEnterprise Manager, MS Access and DB2, Informix, Netezza.

Front End Tools: Visual Studio 2000/2005/2010 , Crystal Reports, Power Designer.

Web Tools: .NET Technologies, ASP.NET, C#, HTML, ASP, CSS, DHTML, Java Scripts, XML, U - SQL, XSL, Remoting, WEB- SERVICES, UML, Informatica, API, SQL, SQL loader, SSIS, SSRS, SSAS, T-SQL,PL\SQL, JIRA, Azure Data.

Web Servers: IIS 4.0/5.0, Webspere.

Source Control: MS Source Safe, VSS, AccuRev, SVN, TFS, Bitbucket, Tortoise GIT

Reporting Tools: Crystal Reports, SSRS, Cognos, Hyperion reports, Izenda, Dunda report.

PROFESSIONAL EXPERIENCE

Confidential

Data Modeler / Data Analyst

Responsibilities:

• Update AMC website based on the requirements from marketing team.
• Design physical sub-model with the new requirements and merge it to existing model.
• Written complex stored procedures, views reflect the same on website.
• Design the models for all the source to target and engage with ETL team to load data to EDW.
• Work with many project managers to deliver the multiple projects on crustal deadlines.
• Worked with different vendors associated with AMC, as incoming source files and outgoing files from EDW.
• Uploaded design documents, models, scripts to share point and source control (bitbucket) for production and downstream deployments.
• Maintain company coding standards and work on canonical schemas.
• Read/modified ETL Design Documents & created Mapping Specification Documents.
• Working closely with Business analyst to understand Business requirements.
• Work on Netezza database as EDW and Slack channels for communications.
• Worked on Enterprise Mapping Manager (EMM) tool to store all the mapping documents.
• Converted existing excel mappings into EMM tool.

Environment: ER/ data studio , MS SQL Server 2014, 2008 / 2008r, Business Intelligence (SSIS), Data-Stage, Bitbucket, MDM, Netezza, REST Service, Aqua data studio, Tortoise GIT, Windows XP.

Confidential

Data Modeler / Database Architect

Responsibilities:

• Designing conceptual, logical and physical data models and maintain the existing models.
• Convert normalized data models into de-normalized data models by various data modeling technics and review the same with the data Architects.
• Maintained data repository which consists of definitions of all the data elements.
• Evaluate data models and physical databases for variances and discrepancies.
• Enforce EAI (Enterprise Application Integration) standards and best practices around data modeling efforts.
• Created mapping document with business rules through power designer.
• Worked with DBA to get database scripts and designed models from scripts.
• Generate scripts from the data models from Power designer and process the same to DBA to generate database.
• Maintained conceptual, logical and physical data models along with metadata and use sub versions as versioning tool.
• Worked on different source systems which uses web services calls using API standards.
• Worked with application teams to standardize the data elements and reuse the same across all the models.
• Created standards stereotypes in model and reuse the same across all the models.
• Support application developers, reports developer and keep the models up-to date.
• Prepare plans to move the extraction from application server to data-ware house server.
• Create mapping from Source to raw tables and from raw tables to database needed.
• Optimize and update logical and physical data models to support new and existing projects.
• Proficient in data modeling for real time transactional systems.
• Worked with Data Governance project to implement on source applications.
• Designed dimensional models and created mapping documents to support models.
• Knowledge of Data Lake Analytics.
• Knowledge of Hadoop Architectures.

Environment: Power designer 16.0, PL\SQL, Azure data factory, MS SQL Server 2014, 2008 / 2008r, Business Intelligence (SSIS), TOAD, Data-Stage, SOAP, Subversion, MDM, Mainframe, Sybase, JIRA, SVN, Power designer, IBM DB2, UNIX, SOAP API, Win-SCP and Windows XP.

Confidential

MS BI Lead

Responsibilities:

• Created POC using SSIS package as per requirement.
• Understood and built the ETL environment with the specific toolsets.
• Based on the requirement documents design high level design document for business users and low-level design documents for internal code review.
• Created mapping document extracted from business requirement document and embed them in the tool components.
• Created all the SSIS packages and embed them in SVN for package versioning.
• Reverse and forward engineering of XSD and XML constructs on purchased orders.
• Created and scheduled onetime jobs, on-demand jobs, monthly jobs and daily jobs.
• Conducted calls with offshore team and created work assignments on daily basis.
• Read/modified ETL Design Documents & created Mapping Specification Documents.
• Working closely with Business analyst to understand Business requirements.
• Installed and configured Visual Studio for developing and testing environments.
• Designed complex canonical schema for incoming and outgoing messages.
• Interacting with offshore team in development and support activities.
• Created stored procedures to trigger BizTalk applications and for persisting data into other databases.

Environment: MS SQL Server 2012, Business Intelligence (SSIS/SSRS/SSAS), BizTalk 2010, excel, Azure, Mainframe, Sybase, MDM, JSON Files, PowerPoint, IBM DB2, UNIX, Win-SCP, SharePoint T-SQL, HTML, XML, Windows XP.

Confidential

MS BI Developer / Business Data Analyst.

Responsibilities:

• Identified the sources and target databases and mapped as per the requirement.
• Worked on Data warehousing concepts by gathering the requirements and creating a data model, demonstrated the prototype for new modules.
• Documented the entire migration for future references
• Used SQL Compare and SQL Data Compare for pushing changes from test servers to production servers .
• Generate scripts from the data models from Power designer and process the same to DBA to generate database.
• Worked on warehouse for extracting data and send the files to vendor as per requirement.
• Worked with data modelers and DBA to modify the table structures and dim tables.
• Build the transformation with business rules and added default values.
• Performed Unit testing and QA testing one the ETL job results.
• Understood and built the ETL environment with the specific toolsets .
• Convert data models from Power designer .
• Document the transformations and submit to data governance for approval.
• Created crystal reports and ssrs reports.
• Created and translated the high level technical requirements into DI/ETL design in power point and units of work for the DI development team.

Environment: CDMA tool, MS SQL Server 2000/2005/2008 , SSIS, excel, Mainframe, Sybase, Power designer, IBM DB2, UNIX, WinSCP, SharePoint T-SQL, HTML, XML, Power Designer, Windows XP.