SUMMARY:

• Over six years of IT experience with more than five years in Database Development, Administration, Design, Analysis and Test.
• Hands - on experience using Erwin and MS Visio for Relational Database Modeling and Dimensional Modeling in combination with SSAS to develop OLAP cubes having Star/Snowflake schemas.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Microsoft SQL Server 2005, 2008, R2 server side development including (SSIS, SSRS, SSMS)
• Implemented SSIS,SSRS,SSAS for data warehouse & data mart solutions
• Knowledge of Relational Database Management systems.
• Data migration across different databases like DB2, MS SQL Server, MS access & flat files using SSIS packages.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions and Views
• A solid understanding of Relational Databases
• Experience in creating complex T-SQL(TransactSQL) Stored Procedures and Triggers
• Skills in Maintaining and enhancing the existing data warehouse, exports, and reports
• Perform quality checks on reports and exports to ensure exceptional quality
• Provide business users the data required for metrics and analysis
• Develop new SSIS/SSRS packages to meet business needs
• Hands on experience in Troubleshooting database issues.
• Experience in other Databases like MS Access, and DB2
• Experience in BIA business impact analysis identifies the critical business processes.
• Hands on planning SPOF analysis (define goals of analysiss,plan,and execute, analyze, produce result).
• Test a program that access and manuplate.
• Experience in Creating and maintaining documentation for all projects
• Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements.
• Good interpersonal, Analytical and Communication skills.

TECHNICAL SKILLS:

Skills: Microsoft SQL Server Visual Studio TFS

PROFESSIONAL EXPERIENCE:

Application Programmer/BI developer SQL /SSIS ETL /iShare/PLSQL

Confidential

Responsibilities:

• The Credit Reporting (CR) Disputes History Load Project is a part of the FCRA external mandate as Credit Reporting has a legal responsibility to respond to Disputes within a specified time frame . The LOB uses this information to: ensure disputes are processed in a timely fashion; identity problems associated with the timeline.
• As part of FCRA Credit Reporting dispute Project there are 9 applications in the scope to Analyze and leading an effort to document and create a solution for operational data modeling as well as semantic development. I am also accountable to create ETL solutions for new application development. Commence efforts to migrate disputes history out of current system into a new repository hosted on (CBRM).

Application System Analyst

Confidential,chevey chase, Maryland

Responsibilities:

• Driving an effort and data analytics using big data Spark to have a faster result for futher data streaming. Run data in Hadoop cluster or standalone to develop Business uses cases.
• Working on analytical SQL to determine transformation to Big data using Hadoop
• Dimensional and Relational Modeling, Hierarchies, ETL processing methods, Metadata management, in order to migrate application systems and data Using Inphospher.
• Working closely on HBASE real time Access to Big data.
• Demonstrated experience in conducting workshops with Business Users to gather and analyze current and future Business Intelligence (BI) and Self - Service Reporting requirements.
• Proven experience in demonstrating analytical perspectives, aggregation navigation, and drill through across functional areas
• Experience in documenting business and system requirements, processes, workflows and test plans.
• Creating report and Dash board with Micro Strategy or Qlik reporting.
• Experienced in conducting User, documenting manuals, and supporting User Acceptance testing

Technologies: MS SQL 2014, SSIS,ETL, SSRS,Micro strategy, Qlik, Big data,Hadoop,Spark,Hbase, Inphospher, Hue, Hive, DB visualizer, Erwin, Hive through Putty, Python, VM ware horizonBI Developer/Analyst

Confidential, Fredrick, MD

Responsibilities:

• Loading WFHM (Home Mortgage) data into CLRTY database in several stages like loading data from different libraries (like CRMDATA, BASEL, PORT, WBDATA, SASTEMP, PRODREPR, from SASPROD1 SAS Server to Staging WFHM database in CLRTYServer using SSIS ETL. Maintain Staging WFHM database to Staging CLRTY database for few tables and then finally loading data in CLRTY database.
• Executing BASEL BATCH.sh script to run SAS Program in parallel.
• Data load in CLRTY monthly starting form loading SAS data into CLRTY server through SSIS ETL work flows on Autopsy s jobs by placing trigger files in a folder, then a monthly job which load data from Staging WFHM to Staging CLRTY and to CLRTY.
• Handles and leads various large - scale or highly complex data/database management activities.
• Running job manually through SQL Server Agent. job that has many steps that includes stored procedures inserting current processing month s data, updating existing data and deleting redundant data from CLRTY DB.
• Modifying MS sql store procedures, functions and triggers for business need.
• Establishing cleansing, mapping and enrichment.
• Responsible to support SQL Servers with Sever-changing workloads, and achieving some level of predictable performance (or minimizing variance in plans and performance)

Technologies: MS SQL Server 2000/2008, R2 /2012/ 2014 Visual Studio 2008, 2010,2013 Data tool.NET framework, ADO.net, TFS, UNIX, SASGRID1,SAS,PUTTY,JRRA

SQL Server Database developer /DBA

Confidential, Betehesda Maryland

Responsibilities:

• Creating ETL Processes and upgrading the existing DTS packages to SSIS for on - going data load to TrAMS Application.
• Involving in Writing SQL Queries, Views and Stored Procedures on SQL Server to Support TrAMS Application
• Generating ERD diagram using MySQL for Appian plat form.
• Created stored procedures, triggers, Joins, functions and views.
• Implemented SSIS,SSRS,SSAS for data warehouse & data mart solutions
• Knowledge of Relational Database Management systems.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS. Developed reports that meet client requirements and adhere to coding best practices to ensure data accuracy and report maintainability
• Provided technical support for data issues or inquiries related to client reports
• Collaborated with peers and members of the operations and development teams to meet client deadlines and to achieve company goals
• Involved in SSRS report deployment and report server configuration.
• Developed various types of reports like drill down, matrix, cross tab, ad hoc Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Implement new T-SQL features in SQL Server 2012 like Partitioning, Advanced Error handling, Common Table Expression (CTE) and LINQ.
• Evaluating database structures and data movement from Team environment to TrAMS environment.
• Establishing cleansing, mapping and enrichment.

Confidential, hook sett,New Hampshire

SQL Server Developer

Responsibilities:

• Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production). Assists in the development of logical database designs, data models and relational database definitions across multiple computing environments
• Assisted in the identification and analysis of information flows and interfaces between corporate business processes and in transforming the information into logical data bases and relational database definitions.
• Utilizing independent judgment and discretion, monitored data architecture standards and conventions and provided data model and entity relationship diagrams as required.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers Created Sub - Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.