- FinEngine supports the functions of business analysis, trading analytics, cost analyze and on demand analysis for client side.
- The project involved migrate data into 2008 to 2012 SQL Server and also working with ETL process using SSIS tools transform data to the data warehouse.
- Finally, the project gives more power to the analytical strategist, management and end users enabling them to build their analysis and equip themselves with Ad hoc and OLAP reporting tools.
Responsibilities:
- Performed by following the normalization standards appropriate changes from SQL Server 2005 to SQL Server 2008 to maintain data consistency and data validation.
- Actively participated in gathering Business Requirements Analyzed the Business Requirements, System Specification and implementing the logical design and physical design.
- Creating SSIS Packages by using advanced transformations (PowerPivot Transformation, Derived Columns, Fuzzy Lookup, Term extraction, Condition Split, Aggregate) and also used Custom components such as Audit on Pre-Execute, Audit On Post-Execute, Custom Email Task and Statistics Logging Component.
- Performed create a dynamic SSIS packages using complex expressions, variables and also control flow components such as For Each Loop, container and For Loop to loop over a Directory to load inbound files.
- Applied the Business Rules and the requirement to filter bad data from the system by using Complex T-SQL Statements and implemented in various Constraints and Triggers for Data Consistency.
- Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages
- Responsible for creating the reports based on the requirements using SSRS 2008.
- Wrote a query for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
- Created a different type of reports which include: Cross-tab, Conditional, Drill-down, Sub report, Parameterized report and deployed scheduled Reports in Report Manager using SSRS generating all daily, weekly, monthly and quarterly Reports.
- Monitoring performance and optimizing SQL queries for maximum efficiency
- Modified the existing SSIS packages to meet the changes specified by the users.
Tools & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Business Object 3.1, Oracle 11g, Microsoft Excel