SUMMARY:

• Experienced ETL and BI Developer (SSIS, SSAS, SSRS) and BA
• Have more than 5 years of work experience
• B.Sc. degree in Information System Management and Associate degree in Computer Science
• Strong in creating ETL process, Data warehousing, Data Store concepts, data marts and OLAP technologies.
• Expert in Creating, maintaining and Configuring SSIS packages. 
• Involved working with heterogeneous data source like Excel, Flat file, Oracle, DB2, and SQL Server.
• Expert in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved creating operational reports in SSRS … i.e. Drill - Down, Drill-through, Dashboard, Sub-Report, and Matrix reports for various domains.
• Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities. 
• Involved in Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
• Expert in Database Backup, Recovery and applied necessary SQL Server database Service packs, hotfixes and Security Patches.
• Involved in data matching using fuzzy grouping to sort duplicate records.
• Build a data mart (Star Schema) to answer business intelligence questions.
• Developed an understanding in Business Intelligence to convert data based on the business requirement by using different ETL tools.
• Performed SSIS Package and deployment. The package created includes a variety of transformation such as look up, slowly changing dimensions, aggregate, derived column, conditional split, fuzzy lookup, and multicast and data conversion.
• Studied ETL Framework.
• Designed and Deployed Reports using web interface and report server. Created reports on SSAS cubes with Report Builder.
• Produced table and matrix report with drill down and drill through functionality. Reports includes charts, map and gauge.
• Designed SSAS cubes and build attribute relationship for optimal MDX query performance of hierarchies, facts and dimensions.
• Defined and administered database standards, controls, procedures and documented the same.
• Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role.
• Designed Conceptual, Logical and physical Model of database. 
• Expert in Data conversion, Data modeling, Normalization and SQL Server Enterprise manager. 
• Wrote complex Stored Procedures, User Defined Functions, Views, and creating other database objects.
• Expert in Migration of data from different sources .csv, excel and text files and Oracle to SQL Server.
• Strong ability to work independently and under pressure with excellent in meeting deadline
• Result oriented, motivated, committed and strong in working multiple projects simultaneously
• Exceptional ability to adapt latest technologies with a fast learning curve.

TECHNICAL SKILLS:

Database: Oracle, MS SQL Server 2008/2012/2014 , DB2, MySQL, Access, Excel

Operating System: Windows Server, Linux, Unix

Programming languages: Java, C++, PL/SQL, SQL, T-SQL

Web Technology: XML, HTML, Javascript

Other Technologies: Development Methodologies (Agile and Iterative), Project Management, Enterprise Architecture and SDLC.

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Responsibilities:

• Designed, build and populate a data warehouse to support decision making, business modeling and operation research.
• Implemented Key Performance Indicators to monitor business objectives.
• Created facts, dimension and star schema representation for the data mart and warehouse system.
• Interaction with clients to fulfill business requirements, design & implementation phases. 
• Created customer information to load into database in excel and flat file format.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Create and produce ad hoc reports for the business as needed and per cyclical schedules using Microsoft Excel, SQL Server Reporting Services and SharePoint.  
• Produced documentation for all kinds of reports and packages.
• Responded to clients regarding account information; investigated problems and performed problem resolution
• Cross sold banking products and services

Confidential

Responsibilities:

• Created database tables with various constraints including primary key, foreign key, etc. 
• Extracted data from SQL Server database tables and Oracle database tables into flat data files and Excel sheet.
• Designed Conceptual, Logical and physical Model of database. 
• Expert in Data conversion, Data modeling, Normalization and SQL Server Enterprise manager. 
• Wrote complex Stored Procedures, User Defined Functions, Views, and creating other database objects.
• Designed and created reports based on technical specifications provided. Mapped data between Crystal Reports, Data Marts and the Enterprise Data Warehouse.
• Provided design, implementation and maintenance for custom reports using SQL Server.
• Develop and maintain proficiency the company’s products and services.
• Adhere and apply policies and procedure of corporate office for project management.