PROFESSINAL SUMMARY:

• Highly Motivated database application expert with a consistent, proven track record of excellence, achievement, adaptability, and integrity.
• MBA in MIS (Management Information Systems) and 12+ Years of business and IT consulting experience in Project Management, Database Design, Development and Business Intelligence.
• Proven ability to create and deliver solutions tied to business growth, organizational development and data management optimization. Skilled problem identifier and troubleshooter comfortable managing systems, projects and teams in a range of IT environments.
• Extensive domain knowledge in Banking, Telecommunication, Government, Healthcare, Utility, Manufacture, and e - commerce etc...
• Worked on all activities related to the development, implementation, administration and support of ETL process for large-scale Data Warehouses using SSIS .
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Mapping, Stored Procedure, Constraint, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reporting using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience utilizing Analysis Services in SharePoint integrated mode (PowerPivot for SharePoint), and Power BI.
• Professional DBA experience of SQL Server installation, login and user creation, role and permission configuration, tuning, Log shipping, query optimization and server migration.
• Migration/Conversion experience from SAS, Access, C#, Informatica to SQL Server.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• High availability solutions, performance tuning, advisory and monitoring, and reporting web applications. Freelance experience developing e-commerce, medical, and community based Access or Google web applications. Diverse Expertise in all facets of database architecture, infrastructure, and web development.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Strong ability to learn new skills and new procedures quickly and efficiently. Strong ability to translate business needs into technical requirements.

HIGHLIGHTS OF IT SKILLS:

• SQL Server
• T: SQL
• SSIS
• SSRS
• SSAS
• MS SharePoint
• Power BI
• Data Warehouse
• Tableau
• SpotFire
• BCP utilities
• Crystal Report
• R
• Power View
• Access
• Visio
• Project
• CA Erwin
• TFS
• SAS
• C#
• VBA
• Informatica
• BIML
• Oracle
• CRM
• SEO
• Windows
• TCP/IP
• XML/XLT
• Teradata
• SpotFire
• AWS

EXPERIENCE:

Confidential, Philadelphia, PA

Developer

Responsibilities:

• Assisted client in a smooth transition during a large project team rolling off.
• Learned and supported daily Informatica ETL workflows.
• Resolved various data issues by analyzing data and ETL logics.
• Assisted to optimize ETL performance by re-writing complex queries and converting ETL transformation tasks.
• Responded to queries on ETL code and business logics in the ETL code.
• Responsible for the corporate data month end processes.
• Participated in developing Product Master Data Management (MDM) conversion.
• Created web application login and assisted analyzing login logical architecture.
• Supported corporate Cash Flow forecasting R model.
• Assisted business entity acquisition related code changes.

Confidential, Newark, DE

Database Programmer/Program Manager

Responsibilities:

• Automated existing manual sampling process to increase productivity and accuracy.
• Apply and develop highly advanced data access routines to extract data from OLAP or OLTP source systems for monitoring operations compliance to banking Laws, Rules and Regulations.
• Act independently to uncover and resolve issues associated with finding data that can be used by Compliance Testers to monitor operational compliance.
• Serve as a consultant to Test Designers to ensure appropriate data filters are applied based on business/product needs.
• Lead projects, coordinate across multiple groups to drive projects to completion.
• Utilize SQL Server SSIS, SAS, Oracle, Teradata and Excel etc. to develop ETL programs.

Confidential, DE

SQL BI Database Developer/Architect

Responsibilities:

• Interpreted and implemented business and functional requirements, utilized SSIS and T-SQL to migrate OLTP data from vendor system to in-house system. Write and schedule to run ETL packages and SSRS reports to produce daily reports for internal and external users. Prepared conversion mapping documents. Wrote T-SQL based on business requirements to perform data cleansing.
• Using T-SQL, SSIS and SSRS to convert SAS OLAP processes to SQL Server applications based on existing processes and new design and requirements to streamline the legacy processes.
• Utilizing T-SQL BULK INSERT, BCP utility, T-SQL and SSIS to create automated processes to load data from internal and external sources (data files) to SQL Server databases.
• Migrated C# applications to SQL Server applications.
• Used Team Foundation Server as source code control and change management tool.
• Maintained high availability SQL environments by implementing Log Shipping for TDE (Transparent Data Encryption) Encrypted Database in SQL Server.
• Supported daily production systems. Performed DBA routines.

Confidential

Database Developer/Architect

Responsibilities:

• Gathered and documented requirements and business needs.
• Translated requirements into technical and functional design for back-end solutions.
• Developed, tested, implemented, and supported all aspects of data integration utilizing T-SQL, SSIS, Stored Procedures, C#, and VBA.
• Used 3NF entity model to design OLTP database. Created tables, views, functions, stored procedures, and SSIS packages for validation and loading processes.
• Created and documented unit testing.
• Deployed from Development to Test and from Test to Production.
• Evaluated, analyzed and monitored databases to resolve performance issues.
• Participated in end-user training, support and documentation.
• Created and maintained documentation of processes, databases, applications and procedures.
• Utilized TFS (Team Foundation Server) source control and Rally for Version Control, Agile Planning & Collaboration and Reporting.

Confidential, Vineland, NJ

Senior BI Database Developer

Responsibilities:

• Integrated Analysis Services and Reporting Services with SharePoint to use Power Pivot, Power View, and Reporting Services for SharePoint for Accounting Department.
• Developed variety of Integrated Services Jobs and Reporting Services reports for different service functions.
• Supported production systems including identifying and resolving systems integration issues, such as activities associated database performance, reporting, and .NET applications.
• Reviewed and revised, as required, design of logical and physical data models and file structures.
• Developed and implemented strategies for gathering data from operational databases as well as third-party vendors for inclusion.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Actively supported business users for change requests.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.

Confidential, Lancaster, PA

Application Developer

Responsibilities:

• Analyzed SQL data, created stored procedures and queries.
• Made changes to existing workflows based on client's requirements.
• Took client data and moved it through a service oriented architecture (SOA).
• Built a series of processes from the input stage to the output stage using XML and SLT.
• Utilized Agile Project Management in program developing.

Confidential, DE

Senior Analyst

Responsibilities:

• Created variety of business reports using data from various sources including MUNIS (ERP software) and vendor report web and analyzed and explained the results using variety of tools such as Crystal Report, MS Excel and Access.
• Created Dashboard to analyze the performance of the Monthly, Quarterly & Yearly.
• Under the supervision, established a daily report to help senior management in leading the day to day operations.
• Conducted analysis for ticketing and booting enforcement and collection processes and recommended suggestions to enhance the reporting and verifying procedures.
• Conducted Cost-Benefit analysis for various projects including Digital Parking Permit.
• Streamlined the revenue reconciliation processes for the City Revenue division.

Confidential, Philadelphia, PA

Database Developer

Responsibilities:

• Applied IT general controls concepts and auditing theories, procedures, and techniques to various applications, platforms, databases or operating system environments to ensure Sarbanes-Oxley compliance.
• Extracted and compile data for audit testing using standard software such as SQL Server, Microsoft Access, Excel, and ACL audit software.
• Provided consulting services to the organization on risk and control concerns.
• Supported clients’ management initiate ongoing process improvement initiatives.
• Utilized expertise in flowcharting, process and control mapping, and root cause analysis to assist the projects.